Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-823

SEC_TO_TIME wraps time at 24 hours

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 2.6.2
    • 3.0.0
    • JDBC 4.2 compatibility
    • None
    • Linux, MariaDB 10.3, MariaDB 10.5

    Description

      SEC_TO_TIME should support converting seconds to the TIME data type, inside the representation limits of the TIME data type.

      However, it looks like the JDBC connector wraps the result at 24 hours.

      E.g. using the `mariadb` client:

      MariaDB [(none)]> SELECT SEC_TO_TIME(257394);
      ---------------------

      SEC_TO_TIME(257394)

      ---------------------

      71:29:54

      ---------------------

      E.g. using the JDBC connector to execute the same query:
      23:29:54
      (i.e. 71:29:54 minus 2*24h)

      It might be interesting to note that the MySQL JDBC connector returns `NULL` for the same query.

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            vmsh0 Riccardo Paolo Bestetti
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.