In Mysql (http://www.mysql.com/doc/en/Date_and_time_functions.html)
funnily enough:
NOW() orSYSDATE()
will return what you want.
Regards
M
-Original Message-
From: Arthur [mailto:[EMAIL PROTECTED]]
Sent: 15 October 2002 12:56
To: MYSQL
Subject: Insert default Date
Arthur,
Tuesday, October 15, 2002, 2:56:13 PM, you wrote:
A In access Now() as table field default sets the field when a new
A record is created. In SQL Server there is getdate() suser_sname()
You can't use the return value of a function as a default value.
A Is there an equivalent for
You can use TIMESTAMP field for this. It's automatically assigned current date if you
don't insert anything in this field type or insert null.
-Original Message-
From: Arthur [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 7:56 AM
To: MYSQL
Subject: Insert default Date
TIMESTAMP does what you want, but if you for any reason wish to update records
(mass updates) at the mysql prompt without updating the TIMESTAMP, you'd be out
of luck. For databases where I know that mass updates to data files will be
required, and I want to preserve the user's LAST_MODIFIED