DATEADD with DATEPART

[josieguida02]

I am trying to group records 3 ways in Visual Studio for an excel spreadsheet, by hour, week and month. I have currently have to break apart the date column with a dateadd statement, as my columns that have the times contain a unix date time. I need to make a new column with the dateadd and datepart statements combined.

When I add the datepart statement to the equation the the query fails, and I have to end the task.

Here is an example of the what I currently do break about the unix timestamp in my Microsoft SQL 2008 Database.

DATEADD(ss, HS_Request.dtGMTOpened, '19700101') AS [Date Open]

 

[josieguida02]

This is what I found to work.


DATEADD(ss, - 25200, DATEADD(ss, HS_Request.dtGMTOpened, CONVERT(DATETIME, '1970-01-01 00:00:00', 102))) AS [Date Opened]