[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