Home > DeveloperSection > Forums > Datetime data type
Anurag Chaurasia
Anurag Chaurasia

Total Post:16

Posted on    May-27-2011 1:43 AM

 MSSQL Server MSSQL Server 

 1 Reply(s)
 1233  View(s)
Rate this:
How to insert data into a datetime type column by using sql.................

Uttam Misra

Total Post:124

Posted on    May-27-2011 4:24 AM

insert into tableName values('" + DateTime.Now.ToString("yyyy-MM-dd") + "');

You can also use getdate() function.

Don't want to miss updates? Please click the below button!

Follow MindStick