Re: How to get 'minutes' printed ?

From: Italo Bozzi <ibozzi_at_yahoo.com>
Date: Tue, 8 Jun 1999 14:25:06 -0400
Message-ID: <sgd73.338$wa2.8288_at_maule>


Wassim,

Try this:

select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss' from dual;

I hope this can help you.

Italo Bozzi Feuereisen
Oracle DBA
ICQ: 1342990
mailto:ibozzi_at_yahoo.com

Wassim escribió en mensaje <7jbaov$8d8$1_at_nnrp1.deja.com>...
>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.
Received on Tue Jun 08 1999 - 20:25:06 CEST

Original text of this message