DatePart in MSSQL date & time field

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.

ConstantMeaning
msMillisecond
sssecond
miMinute
hhHour
ddDay
dyDay of Year
dwWeekday
wkWeek
mmMonth
qqQuarter
yyYear

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

Be the first to post comment on this article :


Google+

Post Comment This is for short comments only. Use the forum for more discussions.




Subscribe to our mailing list

* indicates required
Subscribe to plus2net
HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us
©2000-2018 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer