convertion error for string ´´0´´ no IB , alguem me ajude!
estou usando os seguintes parametros em sql no IB com dialect 3
[color=blue:7d28df3b72]select moeda as MOEDA, cast(dt as date) as DATA_DE_COMPRA, cliente as CLIENTE, lancto as LANCAMENTO,
cv as T_MOVIMENTO, qtde as DOLLAR, reais as TOTAL_REAIS from negocios
where dt > ´12/04/2001´ and dt < ´15/04/2001´ [/color:7d28df3b72]
Qaundo utilizo as datas sem aspas tenho a mensagem :
[color=red:7d28df3b72]convertion error for string ´´0´´[/color:7d28df3b72]
e com as aspas tenho :
[color=red:7d28df3b72]convertion error for string ´´15/04/2001´´[/color:7d28df3b72]
a onde estou errando ?
[color=blue:7d28df3b72]select moeda as MOEDA, cast(dt as date) as DATA_DE_COMPRA, cliente as CLIENTE, lancto as LANCAMENTO,
cv as T_MOVIMENTO, qtde as DOLLAR, reais as TOTAL_REAIS from negocios
where dt > ´12/04/2001´ and dt < ´15/04/2001´ [/color:7d28df3b72]
Qaundo utilizo as datas sem aspas tenho a mensagem :
[color=red:7d28df3b72]convertion error for string ´´0´´[/color:7d28df3b72]
e com as aspas tenho :
[color=red:7d28df3b72]convertion error for string ´´15/04/2001´´[/color:7d28df3b72]
a onde estou errando ?
Kanedasam
Curtidas 0
Respostas
Adilsond
12/04/2003
Experimente utilizar
where dt > cast(´12/04/2001´ as date) and dt < cast(´15/04/2001´ as date)
where dt > cast(´12/04/2001´ as date) and dt < cast(´15/04/2001´ as date)
GOSTEI 0