SQL Server DATEFROMPARTS in Snowflake, Databricks and BigQuery

Snowflake has DATE_FROM_PARTS, Databricks has make_date and BigQuery uses DATE(year, month, day). Out-of-range parts behave differently: SQL Server raises an error, Snowflake rolls them over.

SQL Server function: DATEFROMPARTS(year, month, day) · SQL Server docs

Equivalents

Target	Support	Syntax	Notes	Source
Snowflake	Different name	`DATE_FROM_PARTS(year, month, day)`	Values outside the normal ranges are accepted, for example month 13 becomes January of the next year.	Snowflake docs
Databricks	Different name	`make_date(year, month, day)`	Invalid dates return NULL or an error depending on ANSI mode.	Databricks docs
BigQuery	Different name	`DATE(year, month, day)`	Invalid dates raise an error.	BigQuery docs

Behavior differences to check

Snowflake

DATE_FROM_PARTS(2025, 2, 30) returns 2025-03-02 instead of failing. Validate the parts first if bad input should be rejected.

Examples

First day of each month

SQL Server

SELECT DATEFROMPARTS(y, m, 1) AS month_start FROM periods;

Snowflake

SELECT DATE_FROM_PARTS(y, m, 1) AS month_start FROM periods;

Databricks

SELECT make_date(y, m, 1) AS month_start FROM periods;

BigQuery

SELECT DATE(y, m, 1) AS month_start FROM periods;

Other SQL Server functions

CHARINDEX Position of a substring
CONVERT Convert type, with date style codes
CROSS APPLY Join to a correlated subquery or function
DATEADD Add an interval to a date
DATEDIFF Difference between two dates
DATEPART Extract part of a date
EOMONTH Last day of the month
FORMAT Format a value with a .NET pattern
GETDATE Current date and time
IIF Inline if-then-else
ISNULL Replace NULL with a value
LEN Length of a string
NEWID Generate a random UUID
PATINDEX Position of a pattern
STRING_AGG Concatenate values of a group
STRING_SPLIT Split a string into rows
STUFF Replace part of a string
TOP Limit the number of rows
TRY_CAST Cast without failing

Last checked: 2026-10-22 · Paste a whole query into the SQL checker to find every function that needs a change.