Convert Date

[sseeley]

Hi I am looking for some help in converting a date to allow me to submit to a MYSQL datebase. 

 

I want to convert 'dd/mm/yyyy' to 'yyyymmdd'.  For example a user enterd '01/01/2009' and I need to reformat to '20090101' so I can submit to my database.

 

Thanks in advance for any help.

 

Stuart

[DarkSuperHero]

<?php
$date = 'dd/mm/yyyy';  //original string

$piece = explode('/',$date);  //array created by explode, containign different peices of the date...

$date2 = $piece[2].$piece[1].$piece[0];

echo $data2; //returns yyyymmdd

print_r($piece);

/*
array(
[0] =  'dd'.
[1] = 'mm'
[2] = 'yyyy'
)
*/

 

this relies on the input date always being input at the same format....

[ratcateme]

this should do it

$time = strtotime("01/01/2009");
echo date("ymd",$time);

it will also work if the user is missing the leading zeros on the day or month

 

Scott.

 

 

[ratcateme]

<?php
$date = 'dd/mm/yyyy';

$data = explode('/',$date);

$date2 = $data[2].$data[1].$data[0];

echo $data2; //returns yyyymmdd

this still wouldn't work because of leading zeros but your example can also be write as

echo str_replace("/",""$date);

 

Scott.