| | |
Day Function of MSSQL DateTime fieldWe 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.
| day | issue_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 |
| |
| | |
|
|
|
|
|
