Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-691

Add function alias for casting to TIMESTAMPTZ data type

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: None
    • Labels:
      None

      Description

      Currently Optiq does not have a TIMESTAMP with Time Zone data type. Add an alias function in Drill that allows casting easily to TIMESTAMP with Time Zone data type till we have complete support from Optiq.

      So the query to use timestamp with time zone would look like:

      Select timestamptztype(column_name) from foo;

        Attachments

          Activity

            People

            • Assignee:
              mehant Mehant Baid
              Reporter:
              mehant Mehant Baid
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: