how to insert system time in the table using sql query

[Axcelia]

i'm using sql 2008 and .net 2008.... i need to insert system time in the table by using sql query... pls help me

[talk2tim]

Lets say the name of your table is "students" and it has a timestamp,
like this

CREATE TABLE students (
  ts TIMESTAMP,
  description VARCHAR(80));

Then this will do for date and time

INSERT INTO students VALUES (CURRENT_TIMESTAMP);

This will do for just time

INSERT INTO students VALUES (CURRENT_TIME);

or use NOW

INSERT INTO students VALUES ('text holder', NOW());

Let me know if they work. They should all work. :-)

[Installer099]

That should definitely work man!