Hi
how can i update the DATE field in a table
my code is
UPDATE FACTORYORDER
SET DUEDATE =7/30/2001
WHERE olddate =1/6/2004
showing error
suggest me where i need to change
HI,
DO THE FOLLOWING:
1.USE THIS QUERY : SELECT DUEDATE,OLDDATE FROM FACTORYORDER;
2.CHECK THE DATATYPE OF THIS TWO FIELDS AND THEN CHECK THE DATE FORMAT FOR THESE FIELDS.
3.NOW USE THIS QUERY FOR UPDATE:
UPDATE FACTORYORDER SET DUEDATE='30-JUL-2001' WHERE OLDDATE='06-JAN-2004';
NOTICE : ABOVE QUERY WILL UPDATE ALL THE RECORDS HAVING OLDDATE AS '06-JAN-2004'. BE SURE BEFORE COMMIT.