posted 21 years ago
Hello all, I am loading data to a table which has DATE field. By default 'null' is loaded to this field when an insert is performed. On a later stage I want to query for all records that has null date and update the date field with 'current' date.
Can someone tell me how I can do this? When I try the following it does not seem to work:
SELECT * FROM EMP WHERE DATE=null;
Thanks
Suresh