Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
538 Points
136 Posts
Mar 15, 2012 05:09 AM|LINK
Use SYSDATE instead of Today
"INSERT INTO MAPS.GIS(ENTRYDATE,USERID,JOB_NUMBER,ENTRY_TYPE,CHANGE_DESCRIPTION) VALUES("SYSDATE ",'" & "USERID', " & txtJO.Text & ",'" & txtType.Text & "','" & txtDesc.Text & "')" Regards,
mamun22s
Member
538 Points
136 Posts
Re: Insert Today into an oracle table
Mar 15, 2012 05:09 AM|LINK
Use SYSDATE instead of Today
"INSERT INTO MAPS.GIS(ENTRYDATE,USERID,JOB_NUMBER,ENTRY_TYPE,CHANGE_DESCRIPTION) VALUES("SYSDATE ",'" & "USERID', " & txtJO.Text & ",'" & txtType.Text & "','" & txtDesc.Text & "')" Regards,Senior Software Engineer
Ennovia Technologies Limited
(Mark it as answer if it does help you!)