Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Empty dates in SQL Server
Message
De
14/12/2001 05:46:47
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
 
À
13/12/2001 12:36:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00593889
Message ID:
00594307
Vues:
26
Hi just one thing this will allways return an empty cursor since in SQL server there are not such things as an empty date dates will have some value our will be null never empty.

>>Can anyone recommend a good solution for displaying and detecting empty dates in SQL Server (which are returned as 1/1/1900 12:00 AM)?
>>
>>Thanks.
>
>Joel,
>
>If you already have empty dates that show 1/1/1900 you can check for those with '' as in
>
Select * From myTable Where myDateField=''
>HTH
Alexandre Palma
Senior Application Architect
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform