Converting MSSQL GetUTCDate() into PHP/Unix/MySQL Ticks

Question

I'm inserting a DateTime into MsSQL using the GetUTCDate() function provided by MsSQL.

I need to convert the time in C# to show it as the Unix / MySQL integer, so that it can be eventually manipulated with PHP.

I believe the Unix / PHP / MySQL ticks start at 1/1/1970, but I'm not sure how I would convert the equiv MsSql / C# time into this unix standard.

Any help would be appreciated.

Answer 1

DateTime dt = something; //Get from db

TimeSpan ts = dt - new DateTime(1,1,1970); // off the top of my head, check order of params

long ticks = ts.TotalTicks; // again off the top of my head, check property name

Answer 2

You can do this in MSSQL relatively easily. For the current date:

SELECT DATEDIFF(s, CONVERT(DATETIME, '1970-01-01'), GETUTCDATE())

returns the INT number of seconds since 1/1/1970, which is the Unix timestamp.