SQLTeam.com | Weblogs | Forums

Convert GETDATE to military time


#1

Hello,

How do I convert GETDATE() to military time?

For example:

  • 0500 is 05.00 AM
  • 1300 is 01.00 PM
  • 2300 is 11.00 PM
  • etc

Thanks all


#2

convert(varchar(10), GetDate(), 114)


#3

Thank you BustazKool