topic Native SQL - update timestamp. in Application Development and Automation Discussions

Native SQL - update timestamp.

Former Member — Mon, 06 Jul 2009 16:40:35 GMT

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 — Mon, 06 Jul 2009 17:56:17 GMT

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

Kanagaraja L

Former Member — Tue, 07 Jul 2009 08:38:53 GMT

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 — Tue, 07 Jul 2009 09:20:03 GMT

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 — Wed, 12 Aug 2009 07:57:41 GMT

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