[SOLVED] Quick and easy way to truncate a date string?

[Moron]

Lets say that I have a date string in an older database where March 19th, 2004 is expressed as:  3192005

 

How can I truncate this to give me:

 

Month: 3

Day: 19

Year: 2004

 

Thanks!

 

 

[sasa]

what date is string '1112005'?

[hostfreak]

Probably a better way, but here is what I came up with:

 

<?php

    $date = '3192005';
    if (strlen($date) > '7')
    {
        //month with 2 digits
        $month = substr("$date", 0, 2);
        $day = substr("$date", 2, 2);
        $year = substr("$date", 4, 4);
    }
    else
    {
        //month with single digit
        $month = substr("$date", 0, 1);
        $day = substr("$date", 1, 2);
        $year = substr("$date", 3, 4);
    }
    
    echo "Month: $month<br />Day: $day<br />Year: $year";

?>

[Moron]

what date is string '1112005'?

 

That would be January 11, 2005. Trust me, the date format wasn't my decision!

 

[ToonMariner]

you need to be consistent '01112007' would be fine but '1112007' COULD be 1st of november too!!!

 

if you are consitent then hostfreaks soln without the if statement will do the job.

[AndyB]

what date is string '1112005'?

 

That would be January 11, 2005. Trust me, the date format wasn't my decision!

 

So what date string would represent November 1, 2005?

 

I think there needs to be some serious revision to the dates stored in order for the 'conversion' to be of real value.

[hostfreak]

Ah, didn't even take into account a one digit days in my solution. You definitely need some consistency... unless you want it to get long and complicated.

[Moron]

So what date string would represent November 1, 2005?

 

11012005. It's Month (one or two digits, as applicable), 2-digit Day, 4-digit Year. Yeah, it's pretty retarded but that's what I have to work with. I'm thinking that whatever technique I use, I'll need to count from the right, since the day and year are consistent.

 

 

[hostfreak]

My solution should work fine then, if single digit days are preceded with 0.

[Moron]

My solution should work fine then, if single digit days are preceded with 0.

 

It works.

 

Thanks!

 

[hostfreak]

Sorry to bring this back up, but an even better way:

<?php

    $date = '3192005';
    
    $month = (strlen($date) > 7) ? substr("$date", 0, 2) : substr("$date", 0, 1);
    $day = substr("$date", -6, 2);
    $year = substr("$date", -4, 4);
    
    echo "Month: $month<br />Day: $day<br />Year: $year";
    
    
?>

 

Less code