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 |
|
rowter
Yak Posting Veteran
76 Posts |
 Posted - 2011-05-18 : 17:22:49
|
| Hello All, I am importing the data from csv to sqlserver. The problem is with the time column . Even though I am sending the time in 24 hr format ( which i changed in the excel file), when it is saving in the database, it is being saved as 12 hr format( with AM and PM). How can I save the time value in 24 hr format in the sqlserver.Appreciate the Help!!!Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-18 : 17:28:23
|
| If it's a time data type, it's not "saved in 12 hour format". If you need to display it in 24 hour format, use the CONVERT function in your SELECT query. CONVERT is documented in Books Online. |
 |
|
|
|
|
|
Question on Time