How to insert a record sysdate in SQL Explore

Posted by Admin on 29-Dec-2007 01:54

A table has a field named 'sysdate' , Format:'99/99/99' Type is Data.
How can insert a record with the field in SQL Explore.
When i display this field i can only get the current date.
My sql is :"insert pub.mytable (sysdate,partnum) values('03/02/01','mypart')"
"select partnum,sysdate from pub.mytable"

Any Advice?
Many thanks.


All Replies

Posted by Admin on 29-Dec-2007 04:32

Do you receive an error message?

SYSDATE is a SQL92 function returning the current date. Can you try to put the field name into single or double quotes and see if that does a change?

If that does not work, can you rename the field or are there too many dependencies on that name?

This thread is closed