Re: How to mysqldump of table with where condition for all data older than a certain epochtime value

[Dieter Schneider]

Peter Brawley Wrote:
-------------------------------------------------------
> > --where="`EpochTime` > '1470268800975'
>
> Again, that's a Null date. No value is greater
> than Null.
>

Hey, the Header of EpochTime is a big integer. Therefore the value of 1470268800975 can not be NULL!!
I want to get all values which are bigger than this one: 1470268800975

Where is the error on my side?

Peter Brawley Wrote:
-------------------------------------------------------
> WHERE: Timestamp BETWEEN '2016-06-11 09:26:01' AND '2016-08-05 09:26:01'

> ?! Your first Between date is later than the second. Read the manual, http://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html#operator_between.

2016-06-11 means 11th of June

2016-08-05 means 5th of august

Therefore the first can not be greater than the second one. It is wrong what you said before.


so where is my problem located?