Parsing a PHP date within a variable

Question

Right, I'm receiving a date from my mySQL database, the date is saved in a YYYY-MM-DD format, I want to call this as a $date = row['date'] variable and then somehow re-order it in php so that it is a DD-MM-YYYY format instead, I am not sure how I can achieve this though.

Someone please help.

seriousdev · Accepted Answer · 2011-03-02 21:43:05Z

3

SELECT DATE_FORMAT(date_here, "%d-%m-%Y") FROM table_here

answered Mar 2, 2011 at 21:43

seriousdev

7,6758 gold badges47 silver badges52 bronze badges

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

1 Comment

Capsule Over a year ago

Way to go! Always do the maximum using SQL and if really needed, manipulate with PHP.

Duniyadnd · Accepted Answer · 2011-03-02 21:41:08Z

2

$date = "2010-12-23";
echo date("d-m-Y" , strtotime($date));

answered Mar 2, 2011 at 21:41

Duniyadnd

4,0431 gold badge24 silver badges30 bronze badges

3 Comments

Aiden Ryan Over a year ago

But how would i use the date from the SQL database when using that?, sorry i'm a php amateur ):

Capsule Over a year ago

You explain it yourself in your question... $date = row['date'] :-S

Aiden Ryan Over a year ago

Oh my god D:, I'm sorry I just showed how much of an amateur I actually am lol, best answer :)

Community · Accepted Answer · 2023-11-17 19:22:09Z

0

Use DateTime which is a new class in PHP5.

https://www.php.net/manual/en/datetime.construct.php

<?php
    try {
     $date = new DateTime('2000-01-01');
    } catch (Exception $e) {
        echo $e->getMessage();
        exit(1);
    }
    
    echo $date->format('d-m-Y');
?>

edited Nov 17, 2023 at 19:22

CommunityBot

11 silver badge

answered Mar 2, 2011 at 21:44

instigator

1,6875 gold badges16 silver badges27 bronze badges

Collectives™ on Stack Overflow

Parsing a PHP date within a variable

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related