Add days to unix timestamp value in where statement

Question

I have a date stored in a table called grids in a field called g_date_created. It's stored as a unix timestamp. I want to select all rows from grids that have a g_date_created plus X numbers of days between a certain time range.

For example:

Select * FROM grids 
WHERE g_date_created + 3 days BETWEEN timestamp_1 AND timestamp_2

juergen d · Accepted Answer · 2015-09-03 19:22:00Z

2

Select * FROM grids 
WHERE g_date_created + interval 3 day BETWEEN timestamp_1 AND timestamp_2

edited Sep 3, 2015 at 19:22

answered Sep 3, 2015 at 18:44

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Clint C. Over a year ago

That did it, thanks. Just had to changed days to "day"

Clint C. Over a year ago

Sorry, does this work if timestap_1 and timestamp_2 are unix timestamps or do i need to use from_unixtime on them also?

juergen d Over a year ago

I just tried it myself - looks like you don't need the from_timestamp at all: sqlfiddle.com/#!9/15b68/4

Collectives™ on Stack Overflow

Add days to unix timestamp value in where statement

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related