Use this:

GETDATE()

(would be Now() in mysql)