EPOCH DateTime Conversion >= 4 days
in [Programming SQL]
|
Prev: Where to put Stored Procedures in SQL 2005
Next: Is there a way to grant users to view stored procedures.
From: Marc Pointer on 24 Jul 2008 13:56 Hello again, Okay, so it's been nearly a year since inquiring. I'm now curious about getting results from the previous day - just that day only. As always, your help is appreciated. Marc From http://www.developmentnow.com/g/113_2007_7_0_0_1000767/EPOCH-DateTime-Conversion-4-days.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com
From: Marc on 25 Jul 2008 09:45
Solved The following produces what I need to get just "Yesterdays" date results only: SELECT needed_Field1, DATEADD(s, EPOCH_DATE, '19700101') AS CONV_DATE FROM Table WHERE ...AND (DATEPART(dd, DATEADD(s, EPOCH_DATE, '19700101')) = DATEPART(dd, GETDATE() - 1)) Thanks in advance anyway :) Marc From http://www.developmentnow.com/g/113_2007_7_0_0_1000767/EPOCH-DateTime-Conversion-4-days.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com |