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.
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?