Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Sat, Jan 31 2009 8:48 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Its valid (at least I can do it) to enter a timestamp without the time portion. How can you then detect timestamps without the time portion? cast(_start as time) is null doesn't work. Roy Lambert
Sat, Jan 31 2009 11:42 AM	Permanent Link
Fernando Dias Team Elevate	Roy, << Its valid (at least I can do it) to enter a timestamp without the time portion. How can you then detect timestamps without the time portion?>> CAST(_Start AS TIME) = TIME '0:0:0' The default time part is not NULL, it's Zero. -- Fernando Dias [Team Elevate]
Sun, Feb 1 2009 3:54 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Fernando Thanks - I eventually figured it out - I got confused especially by EDBManager showing midnight and standard dbgrids showing a blank. Roy Lambert