Results 1 to 2 of 2
  1. #1
    Join Date
    May 2016
    Posts
    1

    Answered: Null instead '0000-00-00 00:00:00' in mysql 5.7

    Before: mysql 5.6. One of the columns in the table is created as follows:

    `f_stamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
    When i view this field in mysql client or using DataGrip, this field is displayed correctly.

    Now: mysql 5.7. The field is not displayed correctly (more precisely, it is causes en error). I delete from mysql config following flags: NO_ZERO_DATE, NP_ZERO_IN_DATE and STRICT_TRANS_TABLES. And now, looking at this field i see:

    - Using mysql-client: 0000-00-00 00:00:00
    - DataGrip: null
    How to change server's option for support this non-standard datetime value, initialize by '0000-00-00 00:00:00' ?

  2. Best Answer
    Posted by moscas


  3. #2
    Join Date
    Dec 2016
    Posts
    3
    Provided Answers: 1

Tags for this Thread

Posting Permissions

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