Click here to Skip to main content
15,885,998 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
is it possible to convert null value date coloumn into sysdate?

i have 1 record in table whose from date is 1-oct-2010 and to_date is null. i want to return that record by using the following query by only comparing with null

select from A Where .....

AND (('1-NOV-2010' between OM_MERCH_CUST.MC_FM_DT AND OM_MERCH_CUST.MC_TO_DT)

OR('30-NOV-2010' between OM_MERCH_CUST.MC_FM_DT AND OM_MERCH_CUST.MC_TO_DT));
Posted

1 solution

Decode function may helps you..
go through the below link for more info on decode

Decode in Oracle [^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900