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 |
|
kohlhaas77
Starting Member
25 Posts |
 Posted - 2008-07-28 : 11:06:10
|
| I have an issue and I can't figure it out. I have a date column that shows as 2006-10-01 00:00:00.000. I need the date to show as MM/DD/YYYY (10/01/2006). Please help! TIA,Dan |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-28 : 11:10:24
|
quote:
Originally posted by kohlhaas77
I have an issue and I can't figure it out. I have a date column that shows as 2006-10-01 00:00:00.000. I need the date to show as MM/DD/YYYY (10/01/2006). Please help! TIA,Dan
Where do you want to show converted dates?MadhivananFailing to plan is Planning to fail |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-28 : 11:10:44
|
Format it in your front end application
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
kohlhaas77
Starting Member
25 Posts |
Posted - 2008-07-28 : 11:11:28
|
| In SQL Query Analyzer. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-28 : 11:15:19
|
quote:
Originally posted by kohlhaas77
In SQL Query Analyzer.
How does formation matter if you want to view them in Query Analyser?Are you trying to export the result to text files?MadhivananFailing to plan is Planning to fail |
|
|
|
kohlhaas77
Starting Member
25 Posts |
Posted - 2008-07-28 : 11:28:12
|
| Mad...yes, sorry, you are correct. I want it converted so when I export it is will be in mm/dd/yyyy. The file is over the max limit for Excel, so I can't convert it there. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-28 : 11:35:37
|
quote:
Originally posted by kohlhaas77
Mad...yes, sorry, you are correct. I want it converted so when I export it is will be in mm/dd/yyyy. The file is over the max limit for Excel, so I can't convert it there.
SELECT convert(varchar(10),date_col,101) from tableMadhivananFailing to plan is Planning to fail |
|
|
|
kohlhaas77
Starting Member
25 Posts |
Posted - 2008-07-28 : 11:36:57
|
| Thanks, Mad!!!!!!!I am very new/green to SQL. I know my questions are not necessarily being phrased the best at this point, but I am trying. :)Thank you, thank you, thank you! |
|
|
|
|
|
|
|
|
Date Conversion