convert time to 24 hour clock

[Guest_imported]

Anyone know if Sybase has a function to do this? For example 2:00 PM = 1400

Thanks in advance

 

[Tim1]

Hiya,

The way that Sybase shows times is dependant on the language that it is set to. If you look in the Sybase manual, it should show you all the different ways that it can express it.

Tim

 

[Guest_imported]

Probably 'select convert(char,<date_field>,8)' should be it.

 

[RajD]

Hi,

Use this

select convert(char(2),getdate(),8)+right(convert(char(5),getdate(),8),2)


It works for sure

RD