获取日期格式未知的两个日期之间的数据

date format: init(11)
date column value: 1421382119

I have managed to get the dates from the table.

$sqllast = $Db1->query("SELECT * FROM table");
while($row = $Db1->fetch_array($sqllast)) 
{
$date1 = date('Y-m-d', $row['create']);
echo "$date1";
}

Question:

I want to get values from this table using the dates interval. I am not getting idea which format shall I enter the dates. I have tried y-m-d, d-m-y , but it did not work

I tried this query

SELECT * FROM table WHERE create between '2015-01-1'  and '2015-01-30'

Since you are storing a unix_timestamp as your value in column create, you will want to use MySQLs UNIX_TIMESTAMP() to covert your dates to a unix_timestamp

SELECT * FROM table WHERE create between UNIX_TIMESTAMP('2015-01-1') and UNIX_TIMESTAMP('2015-01-30')`?

Since the column type is int, you have to convert your string dates to ints as well.

Try this:

SELECT * FROM `table` WHERE `create` BETWEEN UNIX_TIMESTAMP('2015-01-01')  AND UNIX_TIMESTAMP('2015-01-30')