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 :

plus2net.com




Post your comments , suggestion , error , requirements etc here .




We use cookies to improve your browsing experience. . Learn more
HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer