September 21, 2010 at 4:28 am
is there any possibility to set the date format "dd-mon-yyyy hh24:mm:ss " in SQLServer2k5?... not using convert funtion... i want this format permanently to the database... can anyone suggest me better idea?
September 21, 2010 at 4:58 am
September 21, 2010 at 6:27 am
The article Ashish linked to gives a good explanation as to how the date format works. What you need to remember is that SQL Server does not store date data types as dates but as numerics with base date, so the format of dates is really a dispaly issue.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 21, 2010 at 7:06 am
mail4sha (9/21/2010)
is there any possibility to set the date format "dd-mon-yyyy hh24:mm:ss " in SQLServer2k5?... not using convert funtion... i want this format permanently to the database... can anyone suggest me better idea?
Other posters have explained that this isn't practical, and why.
Can you explain why you would want to do this? Perhaps there is an alternative which could help you.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply