Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sajis79
Starting Member
3 Posts |
 Posted - 2005-05-25 : 00:49:11
|
| HOW TO INSERT DATE IN DD-MM-YYYY FORMAT?HOW TO RETRIVE DATE IN DD-MM-YYYY FORMAT?I AM USING SQL SERVER 2000 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-25 : 01:47:00
|
| set dateformat dmydeclare @t table(d datetime)insert into @t values('12-05-2005')select convert(varchar(20),d,105) from @tMadhivananFailing to plan is Planning to fail |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-05-25 : 09:50:34
|
nonononononoinsert the dang date.return the dang date.LET THE CLIENT FORMAT IT!!!!!11!!!!1!!!!!!eleventyone!! *need more coffee* |
|
|
|
_Raclede_
Starting Member
3 Posts |
Posted - 2005-05-25 : 20:49:43
|
quote:
Originally posted by DonAtWork
nonononononoinsert the dang date.return the dang date.
madhivanan answer was correct.. it will give a DD-MM-YYYY FORMAT.. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-05-25 : 22:05:39
|
| >>madhivanan answer was correctActually, Don is correct. Don't do you formatting with SQL Server. Ever. That date value is now a VARCHAR being returned. Your database layer should return values not formatted text strings.- Jeff |
|
|
|
|
|
|
DATE FORMAT