Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get 'minutes' printed ?
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')
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