t-sql convert a float to a datetime type field?
Posted on 2011-09-06
We have software inhouse where the developer has stored a date and time in a float field in the table.
It looks something like this: 40792.581238
Is there something like the convert function, in t-sql, that will allow me to convert this float value into some that I can convert into something like - mmddyyhhmmss?
What would the code look like - I have to take the field, convert it to a datetime value and then pass into my stored procedure.
Thanks much in advance.