Skip to content

Add or update functions corresponding to make_date, to_time, date_bin, date_trunc for Time data types #19025

@Omega359

Description

@Omega359

Is your feature request related to a problem or challenge?

The time and date scalar functions are missing a fair bit of support for Time datatypes making it hard to work with time values in some situations.

For example, there isn't a simple way to:

  • make a time field from hour, minute, sec (make_time)
  • directly make a time field from a string (to_time). You currently need to first create a timestamp than extract the time component from that.
  • binning times is not supported in date_bin. (fix that or add time_bin)
  • truncate a time field is not supported in date_trunc. (fix that or add time_trunc)

Describe the solution you'd like

Better support for time data types across all expected functions.

Describe alternatives you've considered

No response

Additional context

No response

Metadata

Metadata

Labels

enhancementNew feature or request

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions