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.

Sign up for GitHub

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

Jump to bottom

Add function timezoneOffset #19850

Closed
alexey-milovidov opened this issue Jan 29, 2021 · 2 comments · Fixed by #19962
Closed

Add function timezoneOffset #19850

alexey-milovidov opened this issue Jan 29, 2021 · 2 comments · Fixed by #19962
Assignees
@keen-wolf
Labels
easy task Good for first contributors feature help wanted

Comments

@alexey-milovidov
Copy link
Member

alexey-milovidov commented Jan 29, 2021 •
edited
Loading

Use case:
#19768

timezoneOffset(datetime) will give the offset from UTC in seconds (how the civil time at the time zone of the data type of the datetime parameter is "later" than the same unix timestamp in UTC).

Example:

timezoneOffset(toDateTime('2020-01-01 01:02:03', 'Europe/Moscow')) = 10800
@alexey-milovidov alexey-milovidov changed the title Add function timeZoneOffset Add function timezoneOffset Jan 29, 2021
@alexey-milovidov alexey-milovidov added help wanted easy task Good for first contributors labels Jan 29, 2021
@keen-wolf
Copy link
Contributor

l'd like to take this one～

@alexey-milovidov
Copy link
Member Author

@keen-wolf It will be very appreciated!

@keen-wolf keen-wolf mentioned this issue Feb 2, 2021
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@keen-wolf keen-wolf

Labels
easy task Good for first contributors feature help wanted
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Implement the timezoneOffset function keen-wolf/ClickHouse
2 participants
@alexey-milovidov @keen-wolf