[Zope] dd/mm/yyyy date into MySQL

[Sion Morris]

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?
Having looked at the Zope Book nothing obvious jumped out.

Regards,

Sion

--
Computer Support
Sion Morris
School of Psychology                       Ysgol Seicoleg
University of Wales, Bangor                Prifysgol Cymru Bangor
Tel: 01248 382469
Fax: 01248 382599