Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Question on blank dates...
Message
 
 
À
09/03/2003 11:43:13
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00763437
Message ID:
00763456
Vues:
14
Hi Kevin,

Sql Server doesn't support empty/blank dates. Nulls usually used to represent unknown dates.

>Is there any way to easily interpret a 'blank date' value from a SQL Server table into an ADO.NET table?
>
>It seems that blank dates come back as 1/1/1900. Other than writing code that checks for that, is there a better way to handle this? [In other words, in VFP I could easily do a test for empty dates with the EMPTY() function]
>
>
>Thanks,
>Kevin
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform