Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6793

TO_TIMESTAMP and TO_TIME are identical to TO_DATE

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • core
    • None

    Description

      currently TO_TIMESTAMP and TO_TIME simply calls TO_DATE.

      There are at least two problems with this:

      • TO_TIMESTAMP only handles milisecond precision, while it should handle nanoseconds
      • Both use the DATE_FORMAT parser, instead of the TIMESTAMP_FORMAT, or TIME_FORMAT one. (these are identical by default)

      Attachments

        Issue Links

          is depended upon by

          Task - A task that needs to be done. PHOENIX-6882 Umbrella Ticket for date/time handling issues

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              stoty Istvan Toth
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: