>From: Jesper Wisborg Krogh [mailto:mysql@stripped]
>Sent: Friday, December 17, 2010 6:07 AM
>To: Jerry Schwartz
>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
>formatted as text. In Access, it looks like
>> This construct is used throughout the table definitions.
>> Is there any alternative to setting the default to something else (NULL,
>example) and moving the "default" into the application code? That would be a
>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
[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.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com