SELECT GETDATE() AS TheDateAndTime

INSERT INTO YourTable (TheDateAndTime)
VALUES (GETDATE())

Razvan