quote: Originally posted by SergioM
I know it's possible, but I don't know how. How do I explicitly call it (in SQL) as a unix timestamp. Or how do I convert to a unix timestamp from the available data above? Thanks
-Sergio I use Microsoft SQL 2008
Check this site: http://technet.microsoft.com/en-us/library/aa226054(v=SQL.80).aspx
Use CONVERT() like examples shown below:
DECLARE @DateTime DATETIME = getdate();
SELECT CONVERT(CHAR(30),@DateTime, 120), 120
UNION
SELECT CONVERT(CHAR(30),@DateTime, 109), 109
UNION
SELECT CONVERT(CHAR(30),@DateTime, 111), 111
UNION
SELECT CONVERT(CHAR(30),@DateTime, 112), 112
UNION
SELECT CONVERT(CHAR(30),@DateTime, 126), 126
UNION
SELECT CONVERT(CHAR(30),@DateTime, 103), 103
|