I am new developer in .net,I Have requirement..like this ,when user pick date from date picker not time only date he/she pick up,then click insert that time ,i want insert that date and time is into Column exist with name "EnterdDate" data type is "DATETIME". by default 00:00:00 is stored in the Time format I don't want to be stroed that values I want store The at the Time insertion MySql Server Time.
Eg:user 12/03/2013 ->insert->click presently assume server time is 13:00:00 i want insert This Date value --> 2013-03-12 13:00:00 ok for me. i don't need the DateAndTime like is :2013-03-12 00:00:00 not Ok for me.*
please give me best answer any body now the above one .