Hi Arjun,
Thanks for your help. It works :)
Appreciate you.
Alican.
ALİCAN ERTÜRK
İŞ ZEKASI UZMANI
MİMARİ VE İŞ ZEKASI MÜDÜRLÜĞÜ
ENERJİSA ENERJİ A.Ş.
-Original Message-
From: Arjun kr [mailto:arjun...@outlook.com]
Sent: Friday, April 06, 2018 12:00 PM
To: user@drill.apache.org
Hi Alican,
Please see if below syntax helps. Looks like hour format is in 24-hour format
(HH instead of hh).
0: jdbc:drill:schema=dfs> select TO_TIMESTAMP('Mon June 04 12:09:56 EET 2001',
'E MMM dd HH:mm:ss ZZZ ') from (values(1));
++
| EXPR$0 |
Hi,
I try to parse timestamp field in Apache Drill .
Our timestamp field format is : 'Wed June 04 12:09:56 EET 2001'
We use this parse function --> TO_TIMESTAMP('Wed June 04 12:09:56 EET 2001',
'E dd hh:mm:ss z ') does not work. We get an error as below :
---