Converting to Oracle Date Format in an Expression

[Bonediggler1]

Hi-

Not sure how to do this. I am trying to get the expression
DATEADD("D",-DAY(GETDATE()),GETDATE()) into Oracle format, i.e. "DD-MMM-YY".

This is for a variable by the way.

Thank you!!

 

[ousoonerjoe]

Take a look at the CONVERT. Remember to return a VARCHAR or it will go right back to the SQL DATETIME format.

--------------------------------------------------
Bluto: What? Over? Did you say "over"? Nothing is over until we decide it is! Was it over when the Germans bombed Pearl Harbor? No!
Otter: Germans?
Boon: Forget it, he's rolling.
--------------------------------------------------