Saturday, February 25, 2012

date format

The date is stored in my DB as a numeric 9(18,9) data type .How can i convert that value into regular data type
HEre are the two dates in my DB.How can i change this into regular data formart.
37774.98856
37728.38941
Thanks.What is it suppose to be?

How about

SELECT CONVERT(datetime,37774.98856)

No comments:

Post a Comment