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