Inserting current system date and time into column

Question

I want to write a stored procedure which can insert current date and time(from system) into table column

Anuja Pawar · Answer

use this INSERT INTO TABLE (COL1) VALUES SELECT getdate() If you need date in one column and time in another then use INSERT INTO TABLE (COL1COL2) VALUES( SELECT convert(varchar(20)getdate()105) SELECT convert(varchar(20)getdate()108)) 105 for date :02-12-2011 108 for time:13:21:43 Hope it helps :)