Monday 19 August 2013

How can I convert this INT field to a usable date field?

How can I convert this INT field to a usable date field?

Working in MS SQL Server 2005. For whatever reason, the DB I am working in
stores their date values as INT. I am needing to determine a date
difference between two 'date' fields but am unsure how to approach this
since they are currently INT. Dates are stored as follows: 20130101 -
YYYYDDMM. Performing a DATEDIFF results in an arithmetic overflow error.
Any ideas on how to either convert two 'date' fields or to find the date
difference between them?

No comments:

Post a Comment