Hi

I want a date field to an SQL 2000 table, to have default value Now() or date() as in Access. Which is the similar functions for SQL?

Thanks

Getdate() will return the current date-time.

thank you tehNellie