3 character abbrevation for month in date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
3 character abbrevation for month in date
Hi All,
My input is sysdate from dual table(i am using ORACLE enterprise stage).
next stage i have a transformer where i am passing some hardcoded message and concatinating this date(sysdate) to one stored procedure stage, which will pass the above message to some table. The message should appear as eg: if sysdate is 22/08/2008 and my message should be xxxxyyyy for 22-AUG-2008.
please give your inputs.
Thanks,
Deepak
My input is sysdate from dual table(i am using ORACLE enterprise stage).
next stage i have a transformer where i am passing some hardcoded message and concatinating this date(sysdate) to one stored procedure stage, which will pass the above message to some table. The message should appear as eg: if sysdate is 22/08/2008 and my message should be xxxxyyyy for 22-AUG-2008.
please give your inputs.
Thanks,
Deepak
Code: Select all
select to_char(sysdate,'DD-MON-YYYY') from dual
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
Thanks Chulett.chulett wrote:...Code: Select all
select to_char(sysdate,'DD-MON-YYYY') from dual
I got the required format but now i have DD-mon-YYYY.
can i get the output as DD-MON-YYYY
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
Thanks Chulett. I got it correct finally.Deepakinstyle wrote:I got month as MON from dual. but when i have inserted this date into the table there am getting as 22-aug-2008.chulett wrote: My example showed that. "MON" = upper-case three character month, "mon" = lower-case. Pick whichever you like. ...
can i have this as 22-AUG-2008
Thanks,
Deepak
Thanks for your suggestions
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: