Search
Search

Mysql Incorrect datetime value when doing select on timestamp with unixtime value

dfherr Published at Dev
30
dfherr

Okay, so I got this probably very easy problem, but only find answers for the opposite approach.

I have this mysql column: timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

when i try to:

select * from table where timestamp > 1440586108

i get the following warning: Incorrect datetime value '1440586108' for column timestamp at row 1

How should i do it properly?

Parris Varney

Timestamp has format yyyy-mm-dd H:i:s

See the docs

What you need is FROM_UNIXTIME()

Select * from table where timestamp > FROM_UNIXTIME(1440586108)

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Mysql Incorrect datetime value when doing select on timestamp with unixtime value

From Dev

Incorrect datetime value in MySQL

From Dev

MySql incorrect datetime value

From Dev

JDBC - MySQL timestamp - Error Code: 1292. Incorrect datetime value

From Dev

Truncated incorrect datetime value mysql

From Java

Incorrect datetime value in MySQL table

From Dev

MySQL 1292 Incorrect datetime value

From Dev

Select datetime and value, when value != LAG(value)

From Dev

Mysql STR_TO_DATE incorrect datetime value

From Dev

Mysql STR_TO_DATE incorrect datetime value

From Dev

Hibernate Incorrect datetime value

From Dev

What is the MYSQL DATE() function doing to my `timeStamp` value?

From Dev

Mysql Invalid datetime format: 1292 Incorrect datetime value

From Dev

Mysql Invalid datetime format: 1292 Incorrect datetime value

From Dev

Symfony- Invalid datetime format: 1292 Incorrect datetime value: '' for column 'timestamp' at row 1

From Dev

MySQL Incorrect DateTime Value for Date older than 1980

From Dev

Need JDBC solution for MySQL Incorrect datetime value error

From Dev

MySQL select MAX(datetime) not returning max value

From Dev

Data truncation: Incorrect datetime value: ''

From Dev

Warning: #1292 Incorrect datetime value

From Dev

PHP DateTime gives incorrect value

From Dev

MySQL: Incorrect string value

From Dev

MySQL incorrect default value

From Dev

MySQL Invalid default value for timestamp when no default value is given.

From Dev

Update datetime timestamp minute value

From Dev

Select2 - incorrect selected value with mysql data

From Dev

mySQL - maximum value for a timestamp

From Dev

select mysql data and set value of a variable based on timestamp column

From Dev

select mysql data and set value of a variable based on timestamp column

Related Related

  1. 1

    Mysql Incorrect datetime value when doing select on timestamp with unixtime value

  2. 2

    Incorrect datetime value in MySQL

  3. 3

    MySql incorrect datetime value

  4. 4

    JDBC - MySQL timestamp - Error Code: 1292. Incorrect datetime value

  5. 5

    Truncated incorrect datetime value mysql

  6. 6

    Incorrect datetime value in MySQL table

  7. 7

    MySQL 1292 Incorrect datetime value

  8. 8

    Select datetime and value, when value != LAG(value)

  9. 9

    Mysql STR_TO_DATE incorrect datetime value

  10. 10

    Mysql STR_TO_DATE incorrect datetime value

  11. 11

    Hibernate Incorrect datetime value

  12. 12

    What is the MYSQL DATE() function doing to my `timeStamp` value?

  13. 13

    Mysql Invalid datetime format: 1292 Incorrect datetime value

  14. 14

    Mysql Invalid datetime format: 1292 Incorrect datetime value

  15. 15

    Symfony- Invalid datetime format: 1292 Incorrect datetime value: '' for column 'timestamp' at row 1

  16. 16

    MySQL Incorrect DateTime Value for Date older than 1980

  17. 17

    Need JDBC solution for MySQL Incorrect datetime value error

  18. 18

    MySQL select MAX(datetime) not returning max value

  19. 19

    Data truncation: Incorrect datetime value: ''

  20. 20

    Warning: #1292 Incorrect datetime value

  21. 21

    PHP DateTime gives incorrect value

  22. 22

    MySQL: Incorrect string value

  23. 23

    MySQL incorrect default value

  24. 24

    MySQL Invalid default value for timestamp when no default value is given.

  25. 25

    Update datetime timestamp minute value

  26. 26

    Select2 - incorrect selected value with mysql data

  27. 27

    mySQL - maximum value for a timestamp

  28. 28

    select mysql data and set value of a variable based on timestamp column

  29. 29

    select mysql data and set value of a variable based on timestamp column

HotTag

Archive