将空日期转换为sysdate [英] convert null date to sysdate

问题描述

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));

推荐答案

解码功能可以为您提供帮助. 通过以下链接获取有关解码的更多信息

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

Decode in Oracle [^]

这篇关于将空日期转换为sysdate的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！