Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql logging problem
to_char(sysdate,'HH:MM:SS') will give you the hours, the current MONTH and the seconds.
I believe you will find using HH:MI:SS to work. Don't feel bad, everyone does this -- MM and MI are the most frequently messed up formats in dates...
On Sat, 12 Apr 1997 12:57:48 GMT, "Mark Aurit" <maurit_at_world.northgrum.com> wrote:
>select substr(to_char(sysdate,'DD-MM-YY'),1,10) run_date from dual;
>select substr(to_char(sysdate,'HH:MM:SS'),1,10) start_time from dual;
>
>** sql script that takes 20 minutes to process
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities