lundi 18 juillet 2016

Convert SmallInt to time

I am trying to convert a smallnt to a time format.

I am using SQL Server 2005 which doesn't support the time datatype.

I am storing the time as 1400 which is a smallint. When retrieving i want it to be converted to a time format. Such as 14:00

Any Ideas or guidance on the matter. If there is an easier way to do it or if the way i am trying is possible?

Thanks

Aucun commentaire:

Enregistrer un commentaire