DatePart constants to collect parts of Date & time field of MSSQL

We can collect a particular date part from any date and time field of MSSQL table. We have to specify which part of the date and time is required. You can get a list of constants used for formatting DatePart function.

Getting Month using DatePart function

We have one date and time field as issue_dt and we want to know the month of this date and time data.

DatePart(month,issue_dt)

We will get month between 1 to 12 here.

Getting the Day of the year

DatePart(dy,issue_dt)

Here we will get the value from 1 to 365 ( days of the year )

Same way we can use the table below and get all the parts from a date and time field of MSSQL table.

Constant	Meaning
ms	Millisecond
ss	second
mi	Minute
hh	Hour
dd	Day
dy	Day of Year
dw	Weekday
wk	Week
mm	Month
qq	Quarter
yy	Year

Let us try this inside one sql query and get the data

rs1.open " select   DatePart(dy,return_dt) as dp from dt  " , conn

Do While Not rs1.EOF 

Response.Write rs1("dp") 

Response.Write "<br>"
rs1.MoveNext
Loop

Adding default date Date Format
ASP Home

DatePart in MSSQL date & time field

Getting Month using DatePart function

Getting the Day of the year