Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Using EXTRACT with NULL values |
Wed, Mar 21 2007 7:43 PM | Permanent Link |
Richard Harding | Using EXTRACT(YEAR FROM DateOfBirth) gives 0 if DateOfBirth is NULL.
I was expecting a NULL value. -- Richard Harding Windella Computer Knowhow 28 Freeman Drive Lochinvar NSW 2321 Australia Phone: 61 2 4930 7336 Mobile: 0419 016 032 email: rharding@wck.com.au |
Thu, Mar 22 2007 10:58 AM | Permanent Link |
"Ole Willy Tuv" | Richard,
<< I was expecting a NULL value. >> You're not the only one Ole Willy Tuv |
Thu, Mar 22 2007 5:39 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Richard,
<< Using EXTRACT(YEAR FROM DateOfBirth) gives 0 if DateOfBirth is NULL. >> Got it, thanks. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |