Hi All

I have time field that have been stored as decimal(5.0).

If the user wants to record the time as say 09:30, they simply type 0930.

Not sure why the field is decimal(5) instead of decimal(4) - but i guess that's another story?

Anyhow, I am wanting to convert this decimal value to a smalldatetime field in another DB.

After 2 days of trying countless formulae (eg: multiply by 1.666666667 and or 0.02777778 [being possible result generated by Excel formulae] and divide by 24/60/60

or using CONVERT, CAST and even combinations of CASE WHEN functions, I have still not found a solution.

How can this be done?

Thanks for any input.