Results 1 to 2 of 2

Thread: mysql: ERROR 1292 (22007): Incorrect date value: '0000-00-00'

  1. 2 Weeks Ago #1
    maketopsite
    maketopsite is offline Frothy Coffee!
    Join Date
    Sep 2019
    Beans
    209

    mysql: ERROR 1292 (22007): Incorrect date value: '0000-00-00'

    Code:
    mysql> UPDATE some_table SET some_date_column='2024-04-10' WHERE some_date_column='0000-00-00' ;
ERROR 1292 (22007): Incorrect date value: '0000-00-00' for column 'some_date_column' at row 1
    Server version: 8.0.26 MySQL Community Server - GPL

    What is please optimal solution ?
    Advanced reply Adv Reply   Reply With Quote Reply With Quote
  2. 3 Days Ago #2
    ruwolf
    ruwolf is offline Spilled the Beans
    Join Date
    Jan 2020
    Beans
    12

    Re: mysql: ERROR 1292 (22007): Incorrect date value: '0000-00-00'

    Why do you post this question in multiple forums?
    You have already get answer here.
    Advanced reply Adv Reply   Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Ubuntu Forums Code of Conduct