SQL Convert style values
Posted on 2004-11-01
I am trying to convert from "July 30, 2004" to "JULY 30, 2004". I have the code for the short date i.e. JUL 30, 2004 but I need the month spelled out. This date field is being built in a work table inside a stored procedure then it is passed into Crystal Reports v8.0. I would like to do all the date formating inside the stored procedure so I don't run into Crystal issues down the road when I do my upgrade project.
Here is what I am doing so far:
This Outputs: JUL 30, 2004 I want JULY 30, 2004
Is there an undocumented style number that will do this or do I need to perform some crazy formating or write a case statement?
Any help would be appreicated.