OraFAQ Forum: SQL & PL/SQL

Fri, 08 March 2002 15:41

Raj
Messages: 411
Registered: November 1998

Senior Member

Hi
i have date field which is nullable
i want to know
how to select sysdate if the field iam selecting is null.

Thanks
Raj

Fri, 08 March 2002 15:55

raji
Messages: 30
Registered: February 2002

Member

you can use
select nvl(datefieldname,sysdate) from table name;
This gives sysdate whenever the value of datefieldname is null.

Previous Topic:	varying elements in IN list
Next Topic:	How can I compare a string with 2 digits?

Goto Forum:

]

Current Time: Thu Apr 25 00:01:54 CDT 2024