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 |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2012-03-23 : 18:01:53
|
| HI All,i have one date column which is resulting value like this 03/23/2012 17:53:48 but i want this to be change into 2012-03-23 17:41:41.853Please suggest |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-03-23 : 18:47:51
|
| It is best to format data at the application layer. If you absolutely need to the CONVERT function can do this using a Style value of 121. Ex. [CODE]select convert(varchar(30), MyDateColumn, 121) from MyTable;[/CODE]=================================================It is not so much our friends' help that helps us as the confident knowledge that they will help us. -Epicurus, philosopher (c. 341-270 BCE) |
 |
|
|
|
|
|
Date Format