How can insert a record with the field 'sysdate' in

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

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:35

I have already posted this reply to your post in the code-share section. Somehow I believe, this is the forum (out of those that you posted to) that makes the most sense, so please excuse the double-post of the reply...

........................................

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