Native SQL - update timestamp.

[Former Member]

Hello all,

I have to write native sql code to update the date and time stamp on an oracle database in the format 22/05/2009 02:37:33

I was able to update date by passing 22-MAY-2009 through the native sql, how do i update time ? Any ideas?

[Kanagaraja_L]

Just chk your existing DB DATE and Time which format it was stored.

Kanagaraja L

[Former Member]

How does that matter. All I am doing is passing my date through a variable in the native sql. it has no relation with my system settings

[former_member222860]

you can define a time variable uisng sy-uzeit.

It gives the time format you've mentioned

data: v_time like sy-uzeit.
write:/ v_time.

[Former Member]

Found the solution. I was supposed to use to_date oracle function in my native sql