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

---

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
 

quote:

---

Originally posted by MuMu88
Use CONVERT() like examples shown below:

---