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.
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 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 All rights reserved worldwide Privacy Policy Disclaimer