>-----Original Message----- >From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br] >Sent: Friday, December 17, 2010 6:11 AM >To: mysql@lists.mysql.com >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: je...@gii.co.jp Web site: www.the-infoshop.com >-- >João Cândido de Souza Neto > >""Jerry Schwartz"" <je...@gii.co.jp> escreveu na mensagem >news:011201cb9d6c$eccc1e60$c6645b...@co.jp... >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:je...@gii.co.jp> je...@gii.co.jp > >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/mysql?unsub=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org