All I found is a list of predefined
DateFormat that I can choose from, like this
As I remember in MySQL (and PostgeSQL too?) you can define your Date Format:
DATE_FORMAT(now(),'&m_%Y') --for 02_2012 etc.
Does SQL Server have the same thing? I see people have to write a function to do such thing, does it have a built-in one?
I just found the
DatePart function. It can take Month as number, but always returns 1 digit, even I use