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.