Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > sql server > answers

How to find the System Date Format?

akashazad's Avatar
Member
  
Join Date: Sep 2007
Location: Aund,Pune
Posts: 36
#1: 3 Weeks Ago
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's Avatar
Expert
  
Join Date: Jun 2007
Posts: 1,925
#2: 3 Weeks Ago

re: How to find the System Date Format?

Yes, there's a way...

Try this:

Expand|Select|Wrap|Line Numbers
  1.  
  2. sp_helplanguage @@language
  3.  
  4.  
Happy Coding!!!


--- CK
akashazad's Avatar
Member
  
Join Date: Sep 2007
Location: Aund,Pune
Posts: 36
#3: 2 Weeks Ago

re: How to find the System Date Format?

Hi CK9663
Thankx for the reply.
Reply

« previous question | next question »

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved