SQL Server DAY() Function

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



SQL Server DAY() Function




❮ SQL Server Functions



Example


Return the day of the month for a date:



SELECT DAY('2017/08/25') AS DayOfMonth;

Try it Yourself »


Definition and Usage


The DAY() function returns the day of the month (from 1 to 31) for a specified date.



Syntax



DAY(date)


Parameter Values





Parameter Description
date Required. The date to return the day of the month from

Technical Details




Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data
Warehouse, Parallel Data Warehouse

More Examples



Example


Return the day of the month for a date:



SELECT DAY('2017/08/13 09:08') AS DayOfMonth;

Try it Yourself »





❮ SQL Server Functions


Popular posts from this blog

Malaysia to Papua New Guinea by motorcycle?

.name

List of Bhojpuri films