How to search on date-time fields using ZSQL Methods

Created by . Last modified on 2003/08/05.

BACKGROUND

In dtml, we can easily restrict the rows we select if they were strings, integers or floats. However, restricting the rows we select by dates is not straightfoward, especially if you are using the ODBC DA. This is how I got mine to work.

HOW

arguments:

Mydate:date

Query template:

select * from activity where activity_date= { ts '<dtml-var Mydate fmt=ISO>'}