SQL Server Forums - 24 Hrs Format

Home | Weblogs | Forums | SQL Server Links

SQL Server Forums

Register Now and get your question answered!

All Forums

24 Hrs Format

New Topic

Author

Topic

sanjay5219
Posting Yak Master

178 Posts

Posted - 05/09/2012 : 09:20:24

Hi All,
I wanted to convert this value in 24 hrs format please suggest.
Table Name : t1
Column_Name : TT1

1900-01-01 01:20:00.000

sunitabeck
Flowing Fount of Yak Knowledge

5152 Posts

Posted - 05/09/2012 : 09:26:31

You can use the CONVERT function with the appropriate format. Format codes 114,120 and 121 converts to 24 hr clock. For example:

select CONVERT(VARCHAR(32),GETDATE(),120);

Topic

New Topic

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.