Convert DD/MM/YYYY to YYYY/MM/DD ?

[mikemeadeuk]

Hi Guys,

 

I need a way of converting DD/MM/YYYY to YYYY/MM/DD via one php line. any ideas how I would accomplish this?

 

Basically, I have a bit of kit that allows me to change CSV data before it imports into my application. However I seem to only be able to use standard PHP functions and not custom functions.

 

Any ideas would be much appreciated.

 

cheers,

 

mike

 

 

[Jessica]

$date = date("Y/m/d", strtotime($date));

[Pikachu2000]

Homework?

[Barand]

Unfortunately dd/mm/yyyy is not recognised by strtotime (http://forums.phpfreaks.com/index.php?topic=364145.msg1724276#msg1724276).

 

list ($d, $m, $y) = explode('/', $dateStr);
$ymd = date ('Y-m-d', mktime(0,0,0,$m, $d, $y));

[Jessica]

I always forget that it can't accept that format.

 

[mikemeadeuk]

Hi Guys,

 

thanks for the replys. I am limited to what I can do, as I can only enter the php code into a text box. This is the instructions I have:

 

------

Advanced expressions use php eval() function, it can be also very powerful, example:

{{substr("{item.expiry_date}",0,4}}

------

 

 

Do you know if there is a way to convert the date into the format I need using eval()? If you wondering, {item.expiry_date} refers to the column expiry_date in my CSV file.

 

Please excuse my limited knowledge.

 

thanks

 

mike

 

 

[mikemeadeuk]

just to add, the dates in my CSV are like this:

 

30/08/2012 00:00:00

 

I need them to be like this:

 

2012/08/30 00:00:00

 

Thanks

 

Mike

 

Really appreciate your time guys.

[Barand]

Strange, I could swear I'd given you the code to that. Do you read the responses to your question?

[mikemeadeuk]

Hi Barand,

 

Thanks for the reply, I tried this:

 

{{list ($d, $m, $y) = explode('/', {item.StartDate}); $ymd = date ('Y-m-d', mktime(0,0,0,$m, $d, $y));}}

 

And it didnt work. Am I missing something? thanks for your help.

[Barand]

This is my code applied to your date

 

$dateStr = '30/08/2012 00:00:00';

list ($d, $m, $y) = explode('/', $dateStr);
$ymd = date ('Y-m-d', mktime(0,0,0,$m, $d, $y));

echo $ymd;         //--> 2012-08-30 

 

In which way did it not work?

[xyph]

Curly braces? Dot notation? Seems more like JavaScript

[mikemeadeuk]

Hi, the curly braces are used to apply to php functions before my application imports it.

 

Ahhh, I think the problem is because it is echoing

 

//--> 2012-08-30 

 

I need it to echo:

 

//--> 2012-08-30 00:00:00 

[mikemeadeuk]

....not specifically 00:00:00, whatever the original time is.

[Barand]

I need a way of converting DD/MM/YYYY to YYYY/MM/DD

 

Amazing how goal posts can be moved

 

[PFMaBiSmAd]

I would go the str_replace route to get strtotime to work with that format - $dateStr = str_replace('/','-',$dateStr);

[Barand]

or

$dateStr = '30/08/2012 23:08:45';

list ($d, $m, $y, $h, $i, $s) = sscanf($dateStr, '%d/%d/%d %d:%d:%d');
$ymd = date('Y-m-d H-i:s', mktime($h,$i,$s,$m,$d,$y)) ;

echo $ymd;         //--> 2012-08-30 23-08:45

[mikemeadeuk]

Hi Barand,

 

I did say this...

 

the dates in my CSV are like this:

 

30/08/2012 00:00:00

 

I need them to be like this:

 

2012/08/30 00:00:00

 

Just didnt want to make a huuuuge title. sorry.

 

Any ideas?

[mikemeadeuk]

hi sorry, just seen your reply, ill try that...

 

thanks

[mikemeadeuk]

nope doesnt work. Does this work with eval()?

 

Because this is what the software uses.

 

thanks

 

mike

[scootstah]

nope doesnt work. Does this work with eval()?

 

Because this is what the software uses.

 

Oh god. Stop right there, you're doing something terribly wrong.

[mikemeadeuk]

hi, it works fine in in a standalone php file yes. However I am using magento with this:  http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Value_Replacer

 

And this application uses eval() to allow php functions to alter the CSV file before importing to my magento website.

 

This is what I did, using Barands code, and I placed it within double curly braces as the application advises. And {item.StartDate} refers to StartDate in my CSV file.

 

{{list ($d, $m, $y, $h, $i, $s) = sscanf({item.StartDate}, '%d/%d/%d %d:%d:%d');$ymd = date('Y-m-d H-i:s', mktime($h,$i,$s,$m,$d,$y)) ;}}

 

Any ideas what Im doing wrong?

 

Thanks

 

Mike

[mikemeadeuk]

sorry, this even:

 

{{list ($d, $m, $y, $h, $i, $s) = sscanf({item.StartDate}, '%d/%d/%d %d:%d:%d');{item.StartDate} = date('Y-m-d H-i:s', mktime($h,$i,$s,$m,$d,$y)) ;}}

 

This works perfectly well in a single php file, but if I put it within eval() it highlights as an error, I'm not overly clued up as you can tell, so hopefully someone can point me in the right direction.

 

thanks

[Barand]

if you use PFM's suggestion you can do it as a one-liner

 

$dateStr = '30/08/2012 23:08:45';

$ymd = date('Y-m-d H:i:s', strtotime(str_replace('/','-',$dateStr))) ;

[Barand]

I know I'll probably get banned from this site for using the e function

 

$dateStr = '30/08/2012 23:08:45';

echo eval("return date('Y-m-d H:i:s', strtotime(str_replace('/','-',\$dateStr)));");  //-> 2012-08-30 23:08:45

[Christian F.]

*Readies the tar, feathers, torches and pitchforks.* Bad, Barand, bad! Now you'll have to be punished.

 

mikemeadeuk: I'd advice you to edit the actual code in question, instead of trying to write pseudo-code for a third party wrapper with (apparently) lacking documentation. Reduce the complexity when it is not needed, and you'll find that a whole lot of headaches will simply vanish.