PHP database timestamp format

Question

I have a database with a attribute "DATUM". "DATUM" is a timestamp. Now i want to change the format of the timestamp. Here is a picture of the timestamp with the wrong format

enter image description here

Here with the right format, but at the wrong place

enter image description here

And that the problem. I dont get the "new timestamp" into a echo with the text "geschrieben von Peter am". Maybe someone of you can help me. Here is the code

        /* This should be in 1 echo*/
        /* Like this: 
            $d = date_create($row['DATUM']);
            echo "<a class='article-autor'>geschrieben von $row[AUTOR] am ($d->format('j.m.Y \u\m H:i \U\h\r'))</a>";   

        But it wont work 


        Thats the real code at the moment: */
        echo "<a class='article-autor'>geschrieben von $row[AUTOR] am $row[DATUM]</a>";        
        $d = date_create($row['DATUM']);
        echo($d->format('j.m.Y \u\m H:i \U\h\r'));

You need to format it using PHP and not change it in MySQL.Look at php.net/manual/fr/function.date.php and php.net/manual/fr/function.strftime.php — David Bélanger
– David Bélanger, Commented Feb 1, 2015 at 23:46
put your $d = date_create($row['DATUM']);$d->format('j.m.Y \u\m H:i \U\h\r'); before your echo "<a class='article-autor'>... and then change ... am $row[DATUM]</a> to ... am $d</a> — Sean
– Sean, Commented Feb 1, 2015 at 23:49
Now my code looks like this: $d = date_create($row['DATUM']); $d->format('j.m.Y \u\m H:i \U\h\r'); echo "<a class='article-autor'>geschrieben von $row[AUTOR] am $d</a>";, but i get an error: Catchable fatal error: Object of class DateTime could not be converted to string in — Skeptar
– Skeptar, Commented Feb 1, 2015 at 23:53
Try $d = date_create($row['DATUM']); $datum = $d->format('j.m.Y \u\m H:i \U\h\r'); echo "<a class='article-autor'>geschrieben von $row[AUTOR] am $datum</a>";. Save the formatted DateTime object to a var, and then echo that var. — Sean
– Sean, Commented Feb 1, 2015 at 23:56

Nishanth Matha · Accepted Answer · 2015-02-01 23:49:18Z

1

try this:

echo "<a class='article-autor'>geschrieben von $row[AUTOR] am"."$d->format('j.m.Y \u\m H:i \U\h\r')"."</a>";

answered Feb 1, 2015 at 23:49

Nishanth Matha

6,0892 gold badges22 silver badges29 bronze badges

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

4 Comments

Skeptar Over a year ago

I get 2 errors... Notice: Undefined variable: d in C:\xampp\htdocs\Site\include\news.html on line 13 Notice: Trying to get property of non-object in C:\xampp\htdocs\Site\include\news.html on line 13 geschrieben von Peter am('j.m.Y \u\m H:i \U\h ')

Nishanth Matha Over a year ago

undefined variable?? didn't you put this: $d = date_create($row['DATUM']); before the echo statement?

Skeptar Over a year ago

Yep... I deleted the statement. But it works too! :) Thanks !

Skeptar Over a year ago

Sure, thats no problem :)

Collectives™ on Stack Overflow

PHP database timestamp format

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related