[Zope] Need to use a 'date' data type in sqltest

[Dieter Maurer]

Jones, David H writes:
 > I need to include a test of a date in a DTML variable referenced in a sqltest tag in ZSQL.  From reading documentation and testing, it does not appear that the 'date' data type is supported.
As fas as I know, SQL databases vary greatly in the representation
of times and dates.

If your database accepts string representations for date fields,
you could use an "dtml-var" (rather than "dtml-sqltest") with
an appropriate "fmt" argument.


Dieter