3 character abbrevation for month in date

[Deepakinstyle]

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

[chulett]

Code: Select all

select to_char(sysdate,'DD-MON-YYYY') from dual

[Deepakinstyle]

Code: Select all

select to_char(sysdate,'DD-MON-YYYY') from dual

...

Thanks Chulett.

I got the required format but now i have DD-mon-YYYY.
can i get the output as DD-MON-YYYY

[chulett]

My example showed that. "MON" = upper-case three character month, "mon" = lower-case. Pick whichever you like.

[Deepakinstyle]

My example showed that. "MON" = upper-case three character month, "mon" = lower-case. Pick whichever you like. ...

I got month as MON from dual. but when i have inserted this date into the table there am getting as 22-aug-2008.

can i have this as 22-AUG-2008

Thanks,
Deepak

[Deepakinstyle]

My example showed that. "MON" = upper-case three character month, "mon" = lower-case. Pick whichever you like. ...

I got month as MON from dual. but when i have inserted this date into the table there am getting as 22-aug-2008.

can i have this as 22-AUG-2008

Thanks,
Deepak

Thanks Chulett. I got it correct finally.

Thanks for your suggestions

[chulett]

Ok, good. Saves me from going into my lecture on how Oracle dates are not stored in any format and what they look like when selected is up to you or your tool of choice.

[ray.wurlod]

Has anyone else noticed that Oracle is an anagram of "Orc Ale"? And is occasionally misspelled thus?

[chulett]

No, can't say that I have.