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
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?
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?
Previous Topic: substr and instr functions
Next Topic: using nvl to conquer is null vs. = value in where clause?
Goto Forum:

Current Time: Sat Oct 31 20:14:45 CDT 2020