10.30 Release Notes (Preview)¶
Attention
Content on this page is available in advance of the completion of the 10.30 release, which is currently either pending or in progress and is scheduled for completion on Aug 25, 2026 (subject to change).
Features, updates, or behavior changes described on this page might not be available in your accounts until the release is complete.
For updates to these release notes, see Release notes change log.
SQL updates¶
PERIOD data type (General availability)¶
With this release, Snowflake is pleased to announce the general availability of the PERIOD data type. A PERIOD value
stores an anchored, half-open temporal range [begin, end), with an inclusive beginning bound and an exclusive ending
bound, as a single value. PERIOD values use a DATE, TIME, or TIMESTAMP element type.
Snowflake also provides a family of functions to construct PERIOD values, access their bounds, compare two ranges, and
combine ranges. These functions include PERIOD_CONSTRUCT, PERIOD_BEGIN, PERIOD_END, PERIOD_OVERLAPS,
PERIOD_CONTAINS, PERIOD_INTERSECT, PERIOD_LDIFF, and PERIOD_RDIFF.
Release notes change log¶
| Announcement | Update | Date |
|---|---|---|
| Release notes | Initial publication (preview) | Aug 20, 2026 |