v.23.11New Feature

Added fromDaysSinceYearZero Function Similar to MySQL's FROM_DAYS

Official CH changelog text
Added function fromDaysSinceYearZero which is similar to MySQL's FROM_DAYS. E.g. SELECT fromDaysSinceYearZero(739136) returns 2023-09-08. #56088 (Joanna Hulboj).
Added the fromDaysSinceYearZero function that converts a number representing the days since year zero into a DATE value, similar to MySQL's FROM_DAYS function.

Why it matters

This function provides a simple way to convert integer day counts into corresponding DATE values, improving interoperability with MySQL date calculations and simplifying date arithmetic for users who work with day offsets.

How to use it

Use the function by passing an integer representing the number of days since year zero, for example: SELECT fromDaysSinceYearZero(739136) which returns 2023-09-08.

Related resources

PreviousNext