Francois wrote:

Is it possible to construct this string date on the fly in an SQL method or is it an other solution?

Yes, use the object-relational integration described at: http://www.zope.org/Documentation/Guides/ZSQL/ZSQL-HTML/ZSQL.html#pgfId- 936577 Basically, just write a Python class with a method that does what you want. If this works, please let us know. --Paul Paul Everitt Digital Creations paul@digicool.com 540.371.6909