[Zope] dd/mm/yyyy date into MySQL

Gitte Wange gitte@mmmanager.org
Wed, 16 May 2001 15:08:39 +0200


On Wednesday 16 May 2001 13:43, Tim Cook wrote:
> Sion Morris wrote:
> > Hi,
> >
> > What would be the best way to take a date in the format 'dd/mm/yyyy' from
> > a form and insert it into a date field in a MySQL table, which takes the
> > format yyyy/mm/dd?
> >
> > I could have seperate fields for day, month and year and piece them
> > together before inserting them in the table. But, is it possible to take
> > a complete date, and change it format before inserting it in a MySQL
> > table?
>
> <dtml-var expr="my_date_object.strftime('%Y/%m/%d')">
>
> HTH,

Can you do this in a REQUEST.set or something ?
Because you need to change the content of the variable before inserting it 
into a database ...

Gitte