Home » RDBMS Server » Server Administration » To_Date with Null
To_Date with Null [message #371056] Fri, 18 August 2000 17:10 Go to next message
Bishal
Messages: 1
Registered: August 2000
Junior Member
What happens when i do TO_DATE(NULL,'Jsssss')?
can i do a select statement with a where clause like
dt = TO_DATE(NULL,'Jsssss'); where dt is a date field in table.
Will the above select statement give me all the records with d column as blank?

Report message to a moderator

Re: To_Date with Null [message #371057 is a reply to message #371056] Fri, 18 August 2000 19:47 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
Why can't you just do:
"where dt is null" ?
do you want to avoid the "is null" syntax?

Report message to a moderator

Previous Topic: substr and instr functions
Next Topic: using nvl to conquer is null vs. = value in where clause?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 12 22:07:24 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.