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

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