Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
TIMESTAMP without a time |
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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |