DATEPART() Function in SQL #shorts #shortvideo #sqlserver #dbms #databases #education #mssql #skills

DATEPART() is used to return a specific part of a date as an integer.

Example

SELECT DATEPART(month, '2026-07-16'); -- Output: 7

Key Points

Returns a numeric date part

Supports year, month, day, hour, etc.

Return type is INT

Supported in SQL Server (MSSQL)

⚠️ Always Note

Returns NULL if the input is NULL

weekday result depends on the SET DATEFIRST setting

Use DATENAME() if you need the date part as text

🎯 One-Line

DATEPART() returns a specified part of a date as an integer.

Видео DATEPART() Function in SQL #shorts #shortvideo #sqlserver #dbms #databases #education #mssql #skills канала Dolly Sharma