[Zope] Inserting date/time/boolean fields in table using dtml-sqlvar in ZSQLMethod

Dieter Maurer dieter@handshake.de
Sun, 27 Jan 2002 19:25:40 +0100


Igor Leturia writes:
 >   How can I insert a record in a table using ZSQLMethod, if I have got
 > date, time or boolean fields? dtml-sqlvar allows only string, int, float
 > and nb types.
My experience tells me that date/time handling is not standardized by
SQL and highly database dependant. For Oracle, I always used the
"to_date" function to let Oracle convert a string into a date.


Dieter