Thursday, March 22, 2012

CURRENT_TIMESTAMP - 5 minutes

:shocked: hi,

I want to use CURRENT_TIMESTAMP - 5 minutes in a select and where clause.

I have tried using

CURRENT_TIMESTAMP - 0.004 AS [Time_-6]

But this is not a round off to a whole minute

Also tried

CURRENT_TIMESTAMP, dateadd(minute, datediff(minute, 0, CURRENT_TIMESTAMP) / 5 * 5, 0)

But this will not do wholes seconds e.g

CURRENT_TIMESTAMP = 10.03.33

CURRENT_TIMESTAMP, dateadd(minute, datediff(minute, 0, CURRENT_TIMESTAMP) / 5 * 5, 0) = 10.00.00

Can anyone help??What you want is this, if I understand you correctly:

select dateadd(minute, -5, CURRENT_TIMESTAMP)|||jezemine thanks for the help. worked first time.

your a star

No comments:

Post a Comment