[RESOLVED] Format Time + MSSQL

[obrienkev]

Hi all,

How do I format this time - 5:20PM to look like this.. 17:20:00

Thanks.

Kevin.

[bpat1434]

Using only MSSQL? Or using PHP?

MSSQL

CONVERT(VARCHAR, date/time, 114)

Reference

PHP

date('H:i:s', strtotime('5:20 PM'))