I think I've got the syntax, Jeff: <dtml-var "_.DateTime(birthday)" fmt=aCommon> - birthday is a field returned from my Z SQL Method - The "_.DateTime(birthday)" part creates a DateTime object - The '_' is a reference to the DTML namespace - The DateTime() function creates the DateTime object - The fmt=aCommon part formats it to look like: "May 7, 1966 12:00 am" You can change the format by changing the fmt=XXXX so that XXXX is the format you want from Appdx A of the Zope DTML reference. Eric. // -----Original Message----- // From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of // jeffr@odeon.net // Sent: Tuesday, April 25, 2000 11:12 AM // To: Yanko, Curtis (GSP) // Cc: zope@zope.org // Subject: RE: [Zope] Newbie date/time + MySQL problem // // // // 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 ) // //