Convert GETDATE to military time

Transact-SQL
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