PHP Equivalent of MySQL STR_TO_DATE()?

[Bruce]

I have an application where I would like to be able to allow the user
to specify the date format used throughout the program (for
internationaliz ation).

Then, on a date entry field, I can specify the date format on a MySQL
SELECT to get the date in the proper format.

The Javascript date selector I am using allows me to specify the
format for selecting the date.

Where I am having problems is posting the date back to MySQL. If I was
using v4 of MySQL, I could use STR_TO_DATE(). However, I need to be
able to support version 3 of MySQL, so I need a PHP equivalent to
convert the date in the user-defined format to the MySQL date format.

I can use date() to get a timestamp into the proper format, but how do
I get the user-defined format into a timestamp? strtotime() was the
closest I could find, but that doesn't look like it is going to work
for any format.

Has anyone else run into this? Is there a solution?

--Bruce

[R. Rajesh Jeba Anbiah]

Bruce <bv************ ***@mailblocks. com> wrote in message news:<on******* *************** **********@4ax. com>...
<snip>

I can use date() to get a timestamp into the proper format, but how do
I get the user-defined format into a timestamp? strtotime() was the
closest I could find, but that doesn't look like it is going to work
for any format.

May try <http://www.phpinsider. com/php/code/Date_Calc/>

--
http://www.sendmetoindia.com - Send Me to India!
Email: rrjanbiah-at-Y!com