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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Convert Time Format In Database

Author  Topic 

edwinjoseph82
Starting Member

2 Posts

Posted - 2009-07-30 : 04:30:03
Hi
i need to change the Data for the datetime entry in the DB to 24 hour format. Right now its in 12 hour and that too without AM or PM to indicate the status for morning or evening.

for example: 7:00:00
it can be morning or evening 7.
This is how its stored in db and i need to convert it to 24 hour format.

is it possible?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-07-30 : 04:50:34
Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=130302

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -