Convert dd/mm/yyyy to yyyy/mm/dd for mysql

[frobak]

Hi

 

I need to change a uk date dd/mm/yyyy to mysql format yyyy/mm/dd

 

I have a user form where they enter the date in dd/mm/yyyy string format, i want to take that string, and convert it to mysql format yyyy/mm/dd

 

Possible?

 

Ive searched for ages and havent found a solution that works.

 

Is there an easy solution to this? surely there must be

 

Cheers

[spiderwell]

there is an easy solution

 

use explode to turn the elements into an array then you can re arrange them the right order and turn back into a string/date

 

$arrDate = explode("/","01/12/2012");

 

echo $arrDate[2] . "/" $arrDate[1] . "/" . $arrDate[0]

[sasa]

if you need this for MySQL jou can use str_to_date() and date_format() functions in query

[frobak]

thanks for your reply.

 

So ive tried using the code you supplied, but im getting errors. Heres the code

 

$start_date_pre = $_POST['start_date'];

$arrDate = explode("/","$start_date_pre");

$start_date = "$arrDate[2] . / $arrDate[1] . / . $arrDate[0]";

$sql = "INSERT INTO vacancies SET
vacancy_id= '$_POST[vacancy_id]',
job_title= '$_POST[job_title]',
salary= '$_POST[salary]',
job_salary_range= '$_POST[job_salary_range]',
job_location= '$_POST[job_location]',
job_terms= '$_POST[job_terms]',
start_date= $start_date,
end_date= '$_POST[end_date]',
job_desc= '$_POST[job_desc]'";

 

Can you see where ive gone wrong?

[spiderwell]

yes i can, look carefully again and check your " and ' are in the right place.

 

[sasa]

change line

start_date= $start_date,

to

start_date= str_to_date('$start_date_pre', '%d/%m/%Y'),

[frobak]

heres the code that worked for me.

 

$start_date_pre = $_POST['start_date'];

$arrDate = explode("/","$start_date_pre");

$start_date = $arrDate[2] . "/" . $arrDate[1] . "/" . $arrDate[0];

$sql = "INSERT INTO vacancies SET
vacancy_id= '$_POST[vacancy_id]',
job_title= '$_POST[job_title]',
salary= '$_POST[salary]',
job_salary_range= '$_POST[job_salary_range]',
job_location= '$_POST[job_location]',
job_terms= '$_POST[job_terms]',
start_date= '$start_date',
end_date= '$_POST[end_date]',
job_desc= '$_POST[job_desc]'";

 

Cheers for your help