select MySQL record from date specific date range

Question

I have a problem in fetching data from database, my date fromat is 1438697362 this value comes in result of this php default function time();

I am confused how can I fetch the data with this time and date format.

select * from table_name 
where  created_date 
BETWEEN '1438697362' AND '1440843077'

can anyone please help me in this matter.

@kamranSheikh Checkout this SO answer: http://stackoverflow.com/questions/21032335/mysql-query-between-two-timestamps — Criesto, Sep 08 '15 at 10:18

score 1 · Accepted Answer · answered Sep 08 '15 at 09:56

1

select * from table_name where created_date BETWEEN FROM_UNIXTIME(1438697362) AND FROM_UNIXTIME(1440843077)

or

select * from table_name where UNIX_TIMESTAMP(created_date) BETWEEN 1438697362 AND 1440843077

answered Sep 08 '15 at 09:56

mario.van.zadel

score 0 · Answer 2 · answered Sep 08 '15 at 09:55

0

You can do like this:

SELECT * FROM table_name WHERE created_date > 1438697362 AND created_date < 1440843077

This will select between the 2 date ranges

answered Sep 08 '15 at 09:55

JPJens

score 0 · Answer 3 · edited May 23 '17 at 10:29

0

Which says:

SELECT
  from_unixtime(timestamp) 
FROM 
  your_table

answer by Parkyprg

or put another way:

SELECT other fields here, FROM_UNIXTIME(date_ordered)
FROM orders
WHERE ...

edited May 23 '17 at 10:29

Community

answered Sep 08 '15 at 09:56

Rolf of Saxony

3 Answers3