Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3381

Impala to support AM/PM format in unix_timestamp and from_unixtime

    XMLWordPrintableJSON

    Details

      Description

      Need a way to support below format in unix_timestamp, and from_unixtime if possible:

      20151214 05:15:00.1234 AM
      20151214 05:15:00.1234 PM
      

      An example:

      unix_timestamp('20151214 05:15:00.1234 PM', 'yyyyMMdd HH:mm:ss.SSS PP') 
      

      Of course we can choose a different format, only if we can interpret the AM/PM part of a date time string.

      The function need to support up to nanosecond

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                gaborkaszab Gabor Kaszab
                Reporter:
                Yibing Yibing Shi
              • Votes:
                3 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: