Is the a similar function to NOW()

Hi,

I just imported a MS Access table to SQL Server via DTC. The table has a date field in it that I would like to populate automatically. In fact the access table used the Now() funtion to do just that. Evertime an insert statement occured the current date and time would be inserted into the u_createDate field.

The now function is not working in MS SQL. Is there a similar funciton that will automatically update the u_createDate field when a record in inserted?

MikeYou can use the GETDATE() function.|||Originally posted by manowar
You can use the GETDATE() function.

Thank you, Mike