how to insert the month_year into sql server from textbox?

Posted by Tejamanimala under ASP.NET on 10/18/2013 | Points: 10 | Views : 865 | Status : [Member] | Replies : 1
hi,i want to insert only month_year into sql server from textbox.

i have one textbox,and submit button when i enter the only month and year into textbox,then that month_year should be store into payroll table,which is having Month_Year column,can any one tell me ?



Posted by: Bandi on: 10/18/2013 [Member] [MVP] Platinum | Points: 25

I think no need to have separate Month_Year column.....
Do you have any DATETIME column in the table...?

Refer this link for getting the MM-YYYY format of the DATETIME column in SQL Server

Mark This Response as Answer

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response