[Zope] Passing the current date to an SQL query

Tony McDonald tony.mcdonald@ncl.ac.uk
Mon, 20 Sep 1999 17:21:59 +0100


At 4:55 pm +0100 20/9/99, Peter Whysall wrote:
>What's the best way of doing this?
>
>I'm struggling to find any mention of the *current* date in the
>documentation; I've looked in the Zope DTML User's Guide and the Zope SQL
>Methods User's Guide.
>
>regards
>
>Peter.

that'll be
<dtml-var ZopeTime fmt=aCommon>, which renders the date in the following format
Sep 20, 1999 5:18 pm

the DTML users guide has more of these format strings in Appendix A - 
Date-Time data.

tone

------
Dr Tony McDonald,  FMCC, Networked Learning Environments Project 
http://nle.ncl.ac.uk/
The Medical School, Newcastle University Tel: +44 191 222 5888
Fingerprint: 3450 876D FA41 B926 D3DD  F8C3 F2D0 C3B9 8B38 18A2