How to find the System Date Format?

[akashazad]

Dear Friends
I would Like to know if there is any way we can find the Current Date format of the Server.

I mean is there any Query or function by which we can find out the the Date format on SQL Server is either
"MM/DD/YYYY"
or
"DD/MM/YYYY"
or Any thing Else.

[ck9663]

Yes, there's a way...

Try this:

sp_helplanguage @@language

Happy Coding!!!


--- CK

[akashazad]

Hi CK9663
Thankx for the reply.