MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

Re: MS Access and mySQL TIMESTAMP Problem
Posted by: Brett Bavar
Date: May 23, 2005 09:55AM

How did you get this to work?

When I tried to create a timestamp field with the properties "DEFAULT NOW() ON UPDATE NOW" it ended up having a default of "CURRENT_TIMESTAMP" anyway. When I tried manually changing the default value in MySQL Administrator to "NOW()" it ended up with a default value of "00-00-00 00:00:00" (or something like that).

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MS Access and mySQL TIMESTAMP Problem
9949
Illimar Tambek
May 19, 2005 05:54PM
Re: MS Access and mySQL TIMESTAMP Problem
3772
ruth conde
May 20, 2005 08:43AM
Re: MS Access and mySQL TIMESTAMP Problem
4040
Illimar Tambek
May 21, 2005 11:54PM
Re: MS Access and mySQL TIMESTAMP Problem
3677
Brett Bavar
May 23, 2005 09:55AM
Re: MS Access and mySQL TIMESTAMP Problem
3390
Illimar Tambek
May 27, 2005 02:53PM
Re: MS Access and mySQL TIMESTAMP Problem
3670
webmaster
June 01, 2005 12:14PM
Re: MS Access and mySQL TIMESTAMP Problem
3355
webmaster
June 01, 2005 12:20PM
Re: MS Access and mySQL TIMESTAMP Problem
3840
webmaster
June 01, 2005 12:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.