databendlabs/databend

Feature: Support Date & Timestamp Construction functions

Open

#19,435 opened on Feb 10, 2026

View on GitHub
 (2 comments) (0 reactions) (1 assignee)Rust (880 forks)github user discovery
C-featuregood first issue

Repository metrics

Stars
 (9,314 stars)
PR merge metrics
 (Avg merge 4d 18h) (99 merged PRs in 30d)

Description

Summary

Creates a date, timestamp, timestamp_tz from individual numeric components.

DATE_FROM_PARTS( <year>, <month>, <day> )
TIMESTAMP_FROM_PARTS( <year>, <month>, <day>, <hour>, <minute>, <second> [, <nanosecond> ] [, <time_zone> ] )
TIMESTAMP_TZ_FROM_PARTS( <year>, <month>, <day>, <hour>, <minute>, <second> [, <nanosecond>] [, <time_zone>] )
  • DATE_FROM_PARTS
  • TIMESTAMP_FROM_PARTS
  • TIMESTAMP_TZ_FROM_PARTS

reference https://docs.snowflake.com/en/sql-reference/functions/date_from_parts https://docs.snowflake.com/en/sql-reference/functions/timestamp_from_parts

Contributor guide

Research direction
Examine existing date/time function implementations in the codebase (e.g., DATE PART, EXTRACT) to understand the pattern for adding new functions. Implement DATE FROM PARTS, TIMESTAMP FROM PARTS, TIMESTAMP TZ FROM PARTS following the Snowflake docs. Refer to the query engine's function registration and evaluation flow.
Tech stack
rust
Domain
databasebackend
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
RustSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60