OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Date Format

Fri, 25 August 2006 05:24

monasingh
Messages: 229
Registered: May 2006
Location: Mumbai

Senior Member

Hi,
I have to change the format of date value from
01/01/2006 TO 1/1/06
I have tried using

Select to_char(sysdate,'fm mm/dd/"0"rr hh:mi') from dual;

But this doesn't works if year is like 1999.
In this case the answer returned is 8/25/099.
Please advice.

Thanks ,
Mona

Fri, 25 August 2006 05:34

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Try this:

Select to_char(sysdate,'fm mm/dd/fmrr hh:mi') from dual;

Fri, 25 August 2006 05:42

monasingh
Messages: 229
Registered: May 2006
Location: Mumbai

Senior Member

Thanks,
This worked Smile

Fri, 25 August 2006 05:46

Frank
Messages: 7901
Registered: March 2000

Senior Member

Note the space between fm and mm. It will generate a space in the output. (I don't know whether this is intentionally or not)

[Updated on: Fri, 25 August 2006 05:46]

Fri, 25 August 2006 06:35

monasingh
Messages: 229
Registered: May 2006
Location: Mumbai

Senior Member

Thanks Frank, there is a space. I have removed the space between fm and mm.

Regards,
Mona

Previous Topic:	"dynamic" cursor
Next Topic:	Host String

Goto Forum:

]

Current Time: Tue Dec 10 01:40:00 CST 2024