List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:December 17 2010 2:34pm
Subject:RE: Access to MySQL
View as plain text  
>-----Original Message-----
>From: Jesper Wisborg Krogh [mailto:mysql@stripped]
>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: jerry@stripped
Web site: www.the-infoshop.com



>Regards,
>Jesper



Thread
Access to MySQLJerry Schwartz16 Dec
  • Re: Access to MySQLJesper Wisborg Krogh17 Dec
    • RE: Access to MySQLJerry Schwartz17 Dec
  • Re: Access to MySQLjoao17 Dec
    • RE: Access to MySQLJerry Schwartz17 Dec
      • Re: Access to MySQLMySQL)17 Dec
        • RE: Access to MySQLJerry Schwartz17 Dec