Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

UNIX_TIMESTAMP function parses 1970-01-01T08:00:00+08:00 incorrectly #52869

Open
style1002 opened this issue Nov 13, 2024 · 0 comments
Open

UNIX_TIMESTAMP function parses 1970-01-01T08:00:00+08:00 incorrectly #52869

style1002 opened this issue Nov 13, 2024 · 0 comments
Labels
type/bug Something isn't working

Comments

@style1002
Copy link

style1002 commented Nov 13, 2024

The UNIX_TIMESTAMP function parses 1970-01-01T08:00:00+08:00 incorrectly.

Steps to reproduce the behavior (Required)

SQL: SELECT UNIX_TIMESTAMP('1970-01-01T08:00:00+08:00') as time_zone_foramt, UNIX_TIMESTAMP('1970-01-01 08:00:00') as general_format

Expected behavior (Required)

time_zone_foramt: 0
general_format: 28800

Real behavior (Required)

time_zone_foramt: 28800
general_format: 28800

StarRocks version (Required)

Version: 3.3
system_time_zone Asia/Shanghai
time_zone +00:00

This is the execution result from Apache Druid and ClickHouse.
image

@style1002 style1002 added the type/bug Something isn't working label Nov 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant