How can I store time & date in a 'DAte' data type field? 1

[bnath]

I am using VB6 with oracle 9i as back-end.

I am using the following code to update record which has a 'Date' data type (oracle) field. The update happens correctly, but how can I store even the time in the same field?

strSQL = "UPDATE xxx.AT_VRC_ADVANCES SET
strSQL = strSQL & " , AV_UPDATE_DATE = " & "to_date('" & Format(Now(), "DD-MMM-YYYY") & "', 'DD-Mon-YYYY')"

oRS.Open strSQL, cnn, adOpenForwardOnly, adLockPessimistic

thanks
nath

 

[HarleyQuinn]

How about something like:

"to_date('" & Format(Now(), "DD-MMM-YYYY HH:MM:SS") & "', 'DD-Mon-YYYY HH24:MI:SS')"

Hope this helps


Harleyquinn

---------------------------------
For tsunami relief donations

 

[bnath]

Thank you. It works.

nath