drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vova Vysotskyi <vvo...@gmail.com>
Subject Re: to_date() string to date conversion ERROR
Date Wed, 03 Oct 2018 09:35:34 GMT
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 <herman@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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message