>-----Original Message----- >From: Jesper Wisborg Krogh [mailto:my...@wisborg.dk] >Sent: Friday, December 17, 2010 6:07 AM >To: Jerry Schwartz >Cc: 'MySQL' >Subject: Re: Access to MySQL > >On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote: > >> I have to move the back-end of an Access application to MySQL, and I've run >into one issue that I haven't been able to solve yet. >> >> The Access database stores dates as text in a "yyyy/mm/dd" format. The >problem is that the default value is a formula that generates the current >date, >formatted as text. In Access, it looks like >> >> '=Format$(Now(),\"yyyy/mm/dd\")' >> >> This construct is used throughout the table definitions. >> >> Is there any alternative to setting the default to something else (NULL, >> for >example) and moving the "default" into the application code? That would be a >significant PITA. > >If a 32-bit date range is enough, then you can use the timestamp data type. >That supports having the current time as the default value. See also >http://dev.mysql.com/doc/refman/5.1/en/timestamp.html > [JS] Unfortunately, I have to keep that field as a text field.
Also, a timestamp would change every time a record is updated and you can only have one per record. Thanks for trying. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >Regards, >Jesper -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org