hi
I am having date feild named DATE_PURCH
My requirement is DATE_PURCH<>'1900-01-01'
it is ok
and also i have to handel null for it
date feild compare
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Re: date feild compare
consulting wrote:hi
I am having date feild named DATE_PURCH
My requirement is DATE_PURCH<>'1900-01-01'
it is ok
and also i have to handel null for it
I think you are making a statement. Sometimes its better to ask questions when you want someone to answer it.
![Wink :wink:](./images/smilies/icon_wink.gif)
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom