Home » SQL & PL/SQL » SQL & PL/SQL » Re: Date formats
Re: Date formats [message #2288] Wed, 03 July 2002 11:55
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
sir,

first try to change the different format.if you are not get the answer ,then try this one.

select 'R' || decode(to_char(my_date,'MM'),'01','1','02','2','03','3','04','4','05','5','06','6','07','7','08,'8','09','9',to_char(my_date,MM),to_char(my_date,'MM')) || to_char(my_date,'DD') ....

but it is not a efficient one.

reply to me.

k.sreenivasan

Report message to a moderator

Previous Topic: Partitions
Next Topic: connect at
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 00:20:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.