[Zope] Newbie date/time + MySQL problem

Yanko, Curtis (GSP) YankoC@gspinc.com
Tue, 25 Apr 2000 13:03:06 -0400


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 )