SQL PHP HTML ASP JavaScript articles and free scripts to download
ASP > MSSQL date functions

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 :


Google+

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2015 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer