Hello Herman,
I tried to reproduce this error, but all queries passed on my machine.
Could you please add more details about your env? Which version of Drill is
used, which timezone is set?
Is it reproduced with UTC timezone?
Kind regards,
Volodymyr Vysotskyi
On Mon, Oct 1, 2018 at 10:58 AM Herman Tan <her...@redcubesg.com> wrote:
> Hi,
>
> I have a very puzzling error.
> Try the following SQL statements.
>
> What is the problem with '1982/01/01 00:01:00.000000000'?
> Error message: Illegal instant due to time zone offset transition
>
> select to_date('1981/12/31 00:00:00.000000000','yyyy/MM/dd
> HH:mm:ss.SSSSSSSSS') -- pass
> from (values(1))
>
> select to_date('1981/12/31 11:59:59.000000000','yyyy/MM/dd
> HH:mm:ss.SSSSSSSSS') -- pass
> from (values(1))
>
> select to_date('1982/01/01 00:00:00.000000000','yyyy/MM/dd
> HH:mm:ss.SSSSSSSSS') -- fail
> from (values(1))
>
> select to_date('1982/01/01 00:00:01.000000000','yyyy/MM/dd
> HH:mm:ss.SSSSSSSSS') -- fail
> from (values(1))
>
> select to_date('1982/01/01 00:01:00.000000000','yyyy/MM/dd
> HH:mm:ss.SSSSSSSSS') -- fail
> from (values(1))
>
> select to_date('1982/01/01 01:00:00.000000000','yyyy/MM/dd
> HH:mm:ss.SSSSSSSSS') -- pass
> from (values(1))
>
> select to_date('1982/01/02 00:00:00.000000000','yyyy/MM/dd
> HH:mm:ss.SSSSSSSSS') -- pass
> from (values(1))
>
> select to_date('1983/01/01 00:00:00.000000000','yyyy/MM/dd
> HH:mm:ss.SSSSSSSSS') -- pass
> from (values(1))
>
> Herman
>
