>-----Original Message----- >From: João Cândido de Souza Neto [mailto:[email protected]] >Sent: Friday, December 17, 2010 6:11 AM >To: [email protected] >Subject: Re: Access to MySQL > >What about this? > >date_format(now(), "%Y/%m/%d") > [JS] I don't think you can use anything but a constant as a default value.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: [email protected] Web site: www.the-infoshop.com >-- >João Cândido de Souza Neto > >""Jerry Schwartz"" <[email protected]> escreveu na mensagem >news:[email protected]... >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. > > > >Regards, > > > >Jerry Schwartz > >Global Information Incorporated > >195 Farmington Ave. > >Farmington, CT 06032 > > > >860.674.8796 / FAX: 860.674.8341 > >E-mail: <mailto:[email protected]> [email protected] > >Web site: <http://www.the-infoshop.com/> www.the-infoshop.com > > > > > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
