Leakyradiator
Technical User
I want to insert a month value into a column entitled "month" and the year value into another column entitled "year"...
Can this be done with date/time data types in these columns? And how would you do it?
Everything I've been able to read on how to do it, uses complete mm/dd/yy and I only want to use part of the date. The datepart function seems to only extract the date part from an existing date.
Thanks in Advance
Can this be done with date/time data types in these columns? And how would you do it?
Everything I've been able to read on how to do it, uses complete mm/dd/yy and I only want to use part of the date. The datepart function seems to only extract the date part from an existing date.
Thanks in Advance