Jeff, Working from Monty's lead, this is what worked perfectly for me: ---------------------------------------------------------------------------- ---- FirstName LastName BDay Eric Walstad May 7th, 1966 ---------------------------------------------------------------------------- ---- SQL used: select FirstName, LastName, date_format(Birthday, '%M %D, %Y') as BDay FROM users WHERE FirstName = 'Eric' and LastName = 'Walstad' Thanks Monty! Eric. // -----Original Message----- // From: mtaylor@camelot.information-innovation.com // [mailto:mtaylor@camelot.information-innovation.com]On Behalf Of Monty // Taylor // Sent: Tuesday, April 25, 2000 11:32 AM // To: jeffr@odeon.net // Cc: Yanko, Curtis (GSP); zope@zope.org // Subject: Re: [Zope] Newbie date/time + MySQL problem // // // You're probably right, Zope probably doesn't see the date as a date, but // as a string. Try: // // select date_format(date,'%b %e, %Y') as date from table // // In your SQL query. I'm sure there's a way to map that to a Zope date, // but if you just need the string, this might be a temp. fix. // // Monty // // jeffr@odeon.net wrote: // > // > Hmm, that didn't work. I get a Zope error of: // > // > Error Type: TypeError // > Error Value: not all arguments converted // > // > What I think is the relevent portion of the traceback shows: // > // > File /usr/local/Zope/lib/python/DocumentTemplate/DT_Var.py, // line 313, in render // > (Object: date) // > (Info: ('date', '2000-04-25', {'null': '', 'fmt': // 'aCommon', '': 'date'})) // > // > I think the problem is the string returned from MySQL isn't a // > date object as far as Zope is concerned. // > // > Any help is appreciated, // > // > Jeff // > // > On Tue, 25 Apr 2000, Yanko, Curtis (GSP) wrote: // > // > > Just figured this one out myself a week or two ago. I use // something like // > > this: // > > // > > <dtml-var date fmt=aCommon> // > > // > > If you are using a Zope Date/Time object, this should work. // > > // > > -Curt // > > // > > > -----Original Message----- // > > > From: jeffr@odeon.net [SMTP:jeffr@odeon.net] // > > > Sent: Tuesday, April 25, 2000 12:02 PM // > > > To: zope@zope.org // > > > Subject: [Zope] Newbie date/time + MySQL problem // > > > // > > > // > > > Greetings folks, // > > > // > > > I've got a record in an SQL database that contains a date // > > > field (2000-02-25 for example). // > > > // > > > I'm generating a table from an SQL query. The bit // that displays // > > > the date is pretty simple: <dtml-var date null=""> // > > > // > > > I want to format the date into something a little more readable // > > > (like 'Feb 25, 2000' for example). I've been trying // to figure out // > > > how to use the date-time format functions mentioned in the DTML // > > > guide in Appendix A. It mentions the special variable _, which // > > > provides a method for constructing date time values // from strings // > > > and numeric data. // > > > // > > > I think my question is really a matter of syntax, as the DTML // > > > guide doesn't provide any examples of usage in Appendix A. // > > > // > > > Would I use something like: <dtml-var _.aCommon(date) // null=""> ? // > > > // > > > Any help would be greatly appreciated, // > > > // > > > Jeff // > > > // > > > // > > > _______________________________________________ // > > > Zope maillist - Zope@zope.org // > > > http://lists.zope.org/mailman/listinfo/zope // > > > ** No cross posts or HTML encoding! ** // > > > (Related lists - // > > > http://lists.zope.org/mailman/listinfo/zope-announce // > > > http://lists.zope.org/mailman/listinfo/zope-dev ) // > > // > > _______________________________________________ // > > Zope maillist - Zope@zope.org // > > http://lists.zope.org/mailman/listinfo/zope // > > ** No cross posts or HTML encoding! ** // > > (Related lists - // > > http://lists.zope.org/mailman/listinfo/zope-announce // > > http://lists.zope.org/mailman/listinfo/zope-dev ) // > > // > // > _______________________________________________ // > Zope maillist - Zope@zope.org // > http://lists.zope.org/mailman/listinfo/zope // > ** No cross posts or HTML encoding! ** // > (Related lists - // > http://lists.zope.org/mailman/listinfo/zope-announce // > http://lists.zope.org/mailman/listinfo/zope-dev )