Hi,
It depends... If your field type in database is a
DATETIME, you can retrieve the current datetime using SQL SERVER's function
GETDATE().
INSERT INTO MyTable (MyField)
VALUES (GETDATE())
If your field type in database is a
DATE, you could do it like this:
INSERT INTO MyTable (MyField)
VALUES (CAST(GETDATE() AS TIME))