make_datetime()

Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Creates a datetime scalar value between the specified date and time.

Syntax

make_datetime(year, month, day)

make_datetime(year, month, day, hour, minute)

make_datetime(year, month, day, hour, minute, second)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
year	int	✔️	The year value between 0 to 9999.
month	int	✔️	The month value between 1 to 12.
day	int	✔️	The day value between 1 to 28-31, depending on the month.
hour	int		The hour value between 0 to 23.
minute	int		The minute value between 0 to 59.
second	double		The second value between 0 to 59.9999999.

Returns

If successful, the result will be a datetime value, otherwise, the result will be null.

Example

Run the query

print year_month_day = make_datetime(2017,10,01)

Output

year_month_day
2017-10-01 00:00:00.0000000

Run the query

print year_month_day_hour_minute = make_datetime(2017,10,01,12,10)

Output

year_month_day_hour_minute
2017-10-01 12:10:00.0000000

Run the query

print year_month_day_hour_minute_second = make_datetime(2017,10,01,12,11,0.1234567)

Output

year_month_day_hour_minute_second
2017-10-01 12:11:00.1234567

Related content

• todatetime function