Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Nilson Rishi
  Where is Nilson Rishi?
 Bangkok
 Thailand
 Nilson Rishi
 Tags
Subject: RE: test if a datetime field is empty on SQL
Thread ID: 248690 Message ID: 248714 # Views: 5 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 22, 2009 2:29:32 PM         
   


> > NULL
> > There is no EMPTY or BLANK fields in SQL Server.
>
> Borislav,
> There is no EMPTY or BLANK fields? Or just for some data types?
> Regards,
> Nilson


Blanks - NO
Empty - Yes.
Sorry, my mistake
Datetime fields are the only with NO EMPTY. Just becuase SQL Server keeps them as offset from 01/01/1900. So if you store zero in that fields you will get 01 Jan 1900 in your select.
-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/22/2009 10:45:58 AM
RE: test if a datetime field is empty on SQL Posted by Borislav Borissov @ 12/22/2009 11:11:55 AM
RE: test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/22/2009 12:46:52 PM
RE: test if a datetime field is empty on SQL Posted by Borislav Borissov @ 12/22/2009 2:29:32 PM
RE: test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/23/2009 5:00:37 AM
RE: test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/23/2009 5:00:39 AM
RE: test if a datetime field is empty on SQL Posted by Stefan Wuebbe @ 12/22/2009 11:16:38 AM
RE: test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/22/2009 12:48:31 PM
RE: test if a datetime field is empty on SQL Posted by Stefan Wuebbe @ 12/22/2009 4:11:41 PM