16 May
2001
16 May
'01
1:08 p.m.
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