Skip to content

SELECT toDateTime('1970-01-01 00:00:00') -> 1970-01-01 06:28:16 for time zone other than UTC #3470

@ghuname

Description

@ghuname

Selecting when time zone is not UTC shows wrong (1970-01-01 06:28:16) datetime.

`ClickHouse client version 18.14.10.
Connecting to localhost:9000.
Connected to ClickHouse server version 18.14.10 revision 54409.

blade8.lab.bulb.hr :) SELECT toDateTime('1970-01-01 00:00:00')

SELECT toDateTime('1970-01-01 00:00:00')

┌─toDateTime('1970-01-01 00:00:00')─┐
│ 1970-01-01 06:28:16 │
└───────────────────────────────────┘

1 rows in set. Elapsed: 0.011 sec.`

Metadata

Metadata

Assignees

No one assigned

    Labels

    comp-datetimeDate/DateTime/TimeZone datatypes and date-time semantics.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions