date format from mysql database

Question

I have a column type DATE in mysql database and want to get date in format like this - 21-jan.

$stmt = $db->query('SELECT id, date, title, category FROM posts ORDER BY date DESC'); while($row = $stmt->fetch()){ $date = strtotime($row['date']); $date = date_format($date, "d-M"); // line 49

Warning:
date_format() expects parameter 1 to be DateTimeInterface, integer given... on line 49

Any help ?

lucasxciv · Accepted Answer · 2017-01-21 22:20:06Z

1

Try to do this:

$date = strtolower(date("d-M", $date));

Take a look at date function: http://php.net/manual/pt_BR/function.date.php

edited Jan 21, 2017 at 22:20

answered Jan 21, 2017 at 22:13

lucasxciv

1465 bronze badges

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

1 Comment

qadenza Over a year ago

It works, but can I have 21-jan instead of 21-Jan ?

Oleks · Accepted Answer · 2017-01-21 22:19:44Z

1

Use date function instead of date_format:

$stmt = $db->query('SELECT id, date, title, category FROM posts ORDER BY date DESC'); while($row = $stmt->fetch()){ $date = date("d-M", strtotime($row['date'])); $formatedDate = strtolower($date);

edited Jan 21, 2017 at 22:19

answered Jan 21, 2017 at 22:14

Oleks

1,6411 gold badge18 silver badges22 bronze badges

3 Comments

qadenza Over a year ago

It works, but can I have 21-jan instead of 21-Jan ?

Oleks Over a year ago

@bonaca unfortunately date() function doesn't do that but you can accomplish it with help of strtolower() function

qadenza Over a year ago

Thanks a lot. Solved.

Collectives™ on Stack Overflow

date format from mysql database

2 Answers 2

1 Comment

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Related