Day Function of MSSQL DateTime field

We can collect the day part from the datatime field by using day function in MSSQL database

select day(issue_dt) as day, issue_dt from dt

The output of this query is here.
dayissue_dt
28 12/28/2007 7:54:56 PM
31 10/31/2010 7:23:47 PM
31 10/31/2010 7:30:14 PM
31 10/31/2010 7:30:20 PM
28 2/28/2010 7:54:56 PM

Be the first to post comment on this article :





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




HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2019 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer