Entering the current date and time into a sql server database

TowerMan

Hi I need to insert the current date and time in to a sql server database. I have cretaed a cell in the database called Tme with the data type smalldatetime. I am using the following INSERT command

SqlDataSource1.SelectCommand = "INSERT INTO B_DB (Time) VALUES (System.DateTime.Now)";

But it gives a run time error saying syntax error at ).

So I tired the following " + System.DateTime.Now + " and no joy, I tired creating a sql parameter but it would not allow me to convert System.DateTime.Now to a string to pass it as a sql parameter.

Any idea's and help would be great?

Dr Pepper

I don't know if this will work on the sql you are using, but I use mySQL and there is a simple NOW() function for getting the current datetime:

INSERT INTO B_DB (Time) VALUES (NOW());

Alternatively, perhaps the syntax: System.DateTime.Now() (with parentheses) would work.

Beano

if by sql server you mean Microsoft SQL server then just do

INSERT INTO B_DB (Time) VALUES (getdate());