Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sql logging problem

Re: sql logging problem

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/04/13
Message-ID: <33543452.24515261@newshost>#1/1

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



Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Apr 13 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US