SQL PHP HTML ASP JavaScript articles and free scripts to download

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

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



Join Our Email List
Email:  
For Email Newsletters you can trust
HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

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