[Zope] Newbie date/time + MySQL problem

[Eric L. Walstad]

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 )
//
//