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>
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