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: How to get 'minutes' printed ?

Re: How to get 'minutes' printed ?

From: <shiling_at_math.wayne.edu>
Date: Sat, 05 Jun 1999 16:25:33 GMT
Message-ID: <7jbj1o$alu$1@nnrp1.deja.com>


it is 'mi'.

SQL> l
  1 select to_char(sysdate,'mm/dd/yyyy hh:mi:ss')   2* from dual
SQL> / TO_CHAR(SYSDATE,'MM/DD/YYYYHH:MI:SS')



06/05/1999 12:26:56

In article <7jbaoa$8d3$1_at_nnrp1.deja.com>,   Wassim <net2000_at_francemel.com> wrote:
> Hello,
> Im using PL/SQL and want to print SysDate, i use function to_char with
> the following format string : 'DD/MM/YY - HH:??:SS'
> i don't know what letters to put for 'minutes'
> I think it's too easy question but i didn't find info on the format
> string conventions..
> Thanks for help.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 05 1999 - 11:25:33 CDT

Original text of this message

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