Time in AM & PM - SQL Server Forums

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 2008 Forums

Transact-SQL (2008)

Time in AM & PM

Author

Topic

sg2255551
Constraint Violating Yak Guru

274 Posts

Posted - 2010-09-05 : 12:44:24

hi

I have a field this is stored with datetime datatype. I have managed to cast them to time but it show 24 hours format. How do i get them to display as AM and PM? thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-05 : 14:32:19

You can do this with the CONVERT function and the appropriate style in T-SQL, however you should instead be doing the formatting in the application. Formatting is best done by the presentation layer, your application. What programming language are you using for your app?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog