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

Missing setting to switch default TIMESTAMP, TIME and DATETIME precision

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Configuration
    • None

    Description

      Today I had to invest quite a significant time to switch our system to use sub second precision on timestamp, datetime and time. In the end it required rewriting the relevant parts of the app to actually emit `DATETIME(6)` instead of the more generic DATETIME.

      Here's the kicker though, I would have much rather kept the cross platform compatible SQL and flipped a switch on my DB to instruct it that when I leave off the precision, I actually mean `(6)` [or whatever I configured].

      Is this something you are interested in adding?

      Attachments

        Activity

          People

            Unassigned Unassigned
            dwt Martin Häcker
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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