Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>I am using the ODBC (USER DSN ) , it automatically convert the empty date into
>>>{30/12/1899}. Please anyone has the solution of this problem?
>>
>>A quick scan through past posts would seem to indicate that it would be better to change any date fields that can be empty to accept Nulls instead. Is this practical for you?
>
>
>I can use the following way to work
>==> NVL(left_date,.NULL.) AS left_date <==
>but there is very hard to work with this way.
I can use the following way to work
==> iif(empty(left_date),.NULL.,left_date) AS left_date <==
but there is very hard to work with this way.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement