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

Total Post:16

Points:112
Posted on    May-27-2011 1:43 AM

 MSSQL Server MSSQL Server 
Ratings:


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


Uttam Misra

Total Post:124

Points:888
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