|
-
Apr 6th, 2006, 01:42 PM
#4
Re: Plaese Help urgently"using isNull function is not working plaese post correct fo
 Originally Posted by anwar zaman
the database i am using is not Acess its on Oracle 8i & its datatype is Date
Oracle doesn't have a null date - ALL date fields have data, even if it's "no date". Pick a "null" date and use that as null. (We use 11/17/1858 to mean "no date". Pick one that's legal but impossible - far in the past, 200 years in the future, something that means "null" to you.)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote