Fórum convertion error for string ´´0´´ no IB , alguem me ajude! #154409
12/04/2003
0
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
Curtir tópico
+ 0
Responder
Posts
12/04/2003
Adilsond
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)
Responder
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)