Php Date Function

Question

Got some questions about the php date function.... Here it goes..

I use jquery's datepicker to get the date from the user in the format "day/month/Year". Eg. 23rd of november 2009 is 23/11/2009.

And to manipulate this is php i use the following code...

I store the date string in a variable $date

 $dateOf =  date ('(d-m-Y)', strtotime($date));

The problem i get is that when i pass the date string to the strtotime function it takes the number representing the month as the number representing the date.

Eg : When i give date as 24/12/2009 strtotime takes it as 12/24/2009

I can't get what i am doing wrong here... Will be glad if someone clears this up....

Thanks and Regards

Doug Neiner · Accepted Answer · 2009-11-23 06:08:08Z

1

On the PHP side, you can fix by doing this:

$date = "24/12/2009";
$date = preg_replace('/^(\d{1,2})\/(\d{1,2})\/(\d{2,4})$/','\2/\1/\3', $date);

$dateOf =  date ('(d-m-Y)', strtotime($date));

That just swaps the position of the first and second match taking 24/12/2009 and making it 12/24/2009

Edit:

Without regex :

$date = "24/12/2009";
$date = explode('/', $date);
$date = implode('/', array($date[1], $date[0], $date[2]));

$dateOf =  date ('(d-m-Y)', strtotime($date));

edited Nov 23, 2009 at 6:08

answered Nov 23, 2009 at 6:02

Doug Neiner

66.4k14 gold badges111 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

SpikETidE Over a year ago

Cool work around... :-) Is there anyway to do it without Regex...?

Doug Neiner Over a year ago

I updated my answer to show an alternative. Still seems like a workaround, huh?

SpikETidE Over a year ago

Both are good... Got nothing against Regex...!! I've used this explode technique before, but i thought php, being cool as it is, will have this included in one of the date functions saving us the extra code...!! Thanks all, for your valuable time and suggestions...

Community · Accepted Answer · 2023-11-20 22:45:59Z

1

From the documentation:

The function expects to be given a string containing a US English date format

In the U.S., the month must come before the date, e.g. mm/dd/yyyy

Here's a workaround without Regex:

$date = explode('/', $date);
$dateOf = date('(d-m-Y)', strtotime($date[1].'/'.$date[0].'/'.$date[2]));

edited Nov 20, 2023 at 22:45

CommunityBot

11 silver badge

answered Nov 23, 2009 at 5:54

Matt

44.1k6 gold badges105 silver badges103 bronze badges

1 Comment

Doug Neiner Over a year ago

Sorry it "is" a function, but its depreciated, and if you aren't using regular expressions, explode is the preferred method.

user180100 · Accepted Answer · 2009-11-23 06:09:35Z

strtotime parse an english date Here's an example showing how to do it:

<html>
<head>
<title>Php Date Function</title>
<script type="text/javascript" src="jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="jquery.ui.all.packed.js"></script>
<link rel="stylesheet" src="themes/default/ui.all.css"/>
<script type="text/javascript">
jQuery(document).ready(function($) {
    $('#dpicker').datepicker({
        dateFormat: "dd/mm/yy"
    });
})
</script>
</head>
<body>
    <form action="#" method="POST">
        <input size="25" readonly="readonly" type="text" value="" id="dpicker" name="dpicker" />
        <br/>
        <input type="submit" id="validBtn" value="OK" name="valid" />
    </form>
    <div>
    <?php 
        $d = (isset($_POST['dpicker']) ? $_POST['dpicker'] : null);
        if ($d) {
            $ds = explode("/", $d);
            $dte = date('(d-m-Y)', mktime(0, 0, 0, $ds[1], $ds[0], $ds[2]));
            echo '<p>Date: ' . $dte . '</p>';
        }
    ?>
    </div>
</body>
</html>

Collectives™ on Stack Overflow

Php Date Function

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related