Formatting date (PHP)

Question

I'm having a problem with formatting date with date() function. My code is:

<?
        $vysledek=mysql_query("select * from akce order by datum limit 1");

        while ($zaznam=MySQL_Fetch_Array($vysledek))
            echo 
                "<b>".$zaznam["nadpis"]."</b>"."<br />\n".
                "<i>", 

                date("j.n.Y h:i", $zaznam["datum"]), 

                "</i>"."<br />\n"."<br />\n".
                $zaznam["text"]."<br />\n"."<br />\n"."<br />\n";
?>

The whole data loaded from database displays correctly except the date, which returns 1.1.1970 01:33.

Community · Accepted Answer · 2023-11-17 20:38:18Z

3

$zaznam["datum"] probably isn't a timestamp which is the format the second parameter of date() expects. Use strtotime() to do this:

 date("j.n.Y h:i", strtotime($zaznam["datum"]))

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered Jul 25, 2012 at 14:32

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

Collectives™ on Stack Overflow

Formatting date (PHP)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related