Friday, September 12, 2008

SQL get null date

SELECT NOTIFYID, NULL DATELASTPROCESS FROM E_NOTIFICATION
go
SELECT * FROM E_NOTIFICATION
where DATELASTPROCESS is null
or trunc(DATELASTPROCESS) >= '12-SEP-2008'
go

No comments: