Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-390

ALLOW_INVALID_DATE and >= <= don´t working

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 5.5.25
    • None
    • None
    • None
    • mariadb 5.5.23 linux

    Description

      hi guys i´m running a simple query with

      date_field>="2001-07-06 00:00:00" AND
      date_field<"2012-07-31 24:00:00"

      the second part is 'invalid' "2012-07-31 24:00:00" since hour 24:00:00 don´t exists for this date...
      but, i´m using
      sql_mode=PIPES_AS_CONCAT,ALLOW_INVALID_DATES
      what it should do? convert 24:00:00 to "2012-08-01 00:00:00" ? or just compare as string?

      Attachments

        Activity

          People

            Unassigned Unassigned
            rspadim roberto spadim
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.