The value '0001516993312125' is too long - we must truncate the leading zeroes and the last 3 digits:ĭATEADD(SS, CONVERT(BIGINT, SUBSTRING(JOIN_DATE, 4,10)), '19700101')ģ. The JOIN_DATE column is a string, so it must be converted to a numeric value.ĭATEADD(SS, CONVERT(BIGINT, JOIN_DATE), '19700101')Ģ. However, these failures were instructive, as they led to the solution.ġ. However, my first attempt failed miserably, as did my second and third attempts. I did a quick web search and learned that SQL Server's DATEADD() function was the ticket to what I needed. This was a nice, relatively pithy SQL query and it yielded: After much wailing and gnashing of teeth, I found the format I needed. I decided to convert the string to a date/time format that I was more used to seeing.
To my dismay, the field's value was a string in Unix epoch time - a value representing the number of seconds since January 1, 1970. Searching though a table in a SQL Server database, I found the date field I was looking for.
0 kommentar(er)
