var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Convert Epoch to Date (w/o the Time)
I need to convert Epoch to a Date format in SQL.
And ultimately, I need MSAccess to be able to query against the date.
So, i'd like to trim off the "Time" portion.
Here's what i have so far:
DATEADD(ss, MyTable.EpochDate, CONVERT(DATETIME, '1970-01-01', 101)) AS Date
How can I JUST get the date (and not Time)??
DATEADD(ss, FLOOR(MyTable.EpochDate/86400)*86400, '1970-01-01') AS Date
Originally Posted by simp1eton
note you don't have to convert '1970-01-01' to DATETIME
Nice. That worked great. Thanks!
you're kidding, right?
Originally Posted by becklery
please explain how a MySQL function is supposed to be invoked in a SQL Server query