Click here to Skip to main content
15,847,963 members
Home / Discussions / Database
   

Database

 
Questionsql Date conversion not working in sql 2000 Pin
Robymon7-Jun-12 23:12
Robymon7-Jun-12 23:12 
AnswerRe: sql Date conversion not working in sql 2000 Pin
Bernhard Hiller7-Jun-12 23:41
Bernhard Hiller7-Jun-12 23:41 
AnswerRe: sql Date conversion not working in sql 2000 Pin
Corporal Agarn8-Jun-12 2:30
professionalCorporal Agarn8-Jun-12 2:30 
AnswerRe: sql Date conversion not working in sql 2000 Pin
Simon_Whale8-Jun-12 5:43
Simon_Whale8-Jun-12 5:43 
GeneralRe: sql Date conversion not working in sql 2000 Pin
Corporal Agarn8-Jun-12 5:44
professionalCorporal Agarn8-Jun-12 5:44 
AnswerRe: sql Date conversion not working in sql 2000 Pin
Eddy Vluggen8-Jun-12 2:51
professionalEddy Vluggen8-Jun-12 2:51 
AnswerRe: sql Date conversion not working in sql 2000 Pin
Luc Pattyn8-Jun-12 3:47
sitebuilderLuc Pattyn8-Jun-12 3:47 
AnswerRe: sql Date conversion not working in sql 2000 Pin
PIEBALDconsult8-Jun-12 5:11
mvePIEBALDconsult8-Jun-12 5:11 
If the column is a DATETIME, then the statement "it is saving as MM/DD/YYYY format" is untrue.

If the output of SELECT thedate FROM table shows different formats when executed on different systems, it is because of the "Region and Language" settings of the systems -- see the control panel -- and this is correct behaviour. If you want to override this behaviour (you shouldn't) then format it via the query.

And I strongly reccommend ISO 8601 format YYYY-MM-DD.
AnswerRe: sql Date conversion not working in sql 2000 Pin
vvashishta10-Jun-12 20:09
vvashishta10-Jun-12 20:09 
Questionfunction Pin
Rafat Ali Khan7-Jun-12 22:39
Rafat Ali Khan7-Jun-12 22:39 
AnswerRe: function Pin
Simon_Whale7-Jun-12 22:42
Simon_Whale7-Jun-12 22:42 
AnswerRe: function Pin
vvashishta10-Jun-12 20:10
vvashishta10-Jun-12 20:10 
AnswerRe: function Pin
kmoorevs14-Jun-12 6:08
kmoorevs14-Jun-12 6:08 
QuestionHow to send an invitation mail in c# to a client Pin
rp7867-Jun-12 19:43
rp7867-Jun-12 19:43 
AnswerRe: How to send an invitation mail in c# to a client Pin
Paul Conrad7-Jun-12 19:49
professionalPaul Conrad7-Jun-12 19:49 
AnswerRe: How to send an invitation mail in c# to a client Pin
Sandeep Mewara7-Jun-12 21:04
mveSandeep Mewara7-Jun-12 21:04 
AnswerRe: How to send an invitation mail in c# to a client Pin
vvashishta10-Jun-12 20:11
vvashishta10-Jun-12 20:11 
QuestionSQL Server CLR Parameter Types Pin
cjb1106-Jun-12 5:32
cjb1106-Jun-12 5:32 
AnswerRe: SQL Server CLR Parameter Types Pin
PIEBALDconsult6-Jun-12 5:58
mvePIEBALDconsult6-Jun-12 5:58 
QuestionOR in a JOIN Pin
PIEBALDconsult5-Jun-12 14:51
mvePIEBALDconsult5-Jun-12 14:51 
AnswerRe: OR in a JOIN Pin
Paul Conrad5-Jun-12 15:03
professionalPaul Conrad5-Jun-12 15:03 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult5-Jun-12 15:26
mvePIEBALDconsult5-Jun-12 15:26 
AnswerRe: OR in a JOIN Pin
Luc Pattyn5-Jun-12 17:27
sitebuilderLuc Pattyn5-Jun-12 17:27 
GeneralRe: OR in a JOIN Pin
Paul Conrad5-Jun-12 18:00
professionalPaul Conrad5-Jun-12 18:00 
AnswerRe: OR in a JOIN Pin
Luc Pattyn5-Jun-12 18:31
sitebuilderLuc Pattyn5-Jun-12 18:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.