php fetch date column from database

Question

SELECT c.enddate FROM cohort c ORDER BY c.enddate DESC LIMIT 1

I have a sql query above, it works in database, the result select a date like: '2018-07-18'

I try to use while loop with mysqli_fetch_row in php to fetch this date, but the result will only fetch: 2018

How can I get the whole date?

if ($runquery = $conn->query($result_validation))
{
    //get the enddate from the last cohort
    while ($row = mysqli_fetch_row($runquery))
    {
        $lastDate = $row[0];
    }
}

$row[0] only display first number: 2018.

Can you please post the php code as well? It seems that's where the issue may lie. — Ryan Kozak
– Ryan Kozak, Commented Jul 9, 2018 at 0:28
Are you outputting the result in the loop or just trying to access after? — user3783243
– user3783243, Commented Jul 9, 2018 at 1:25
try adding DATE , SELECT DATE(c.enddate) FROM cohort c ORDER BY DATE(c.enddate) DESC LIMIT 1, if you can add your loop code here — bdalina
– bdalina, Commented Jul 9, 2018 at 1:26
@bdalina Put your code in comments to the answer so that the OP can mark the answer as accepted if your code works. — david
– david, Commented Jul 9, 2018 at 4:52

bdalina · Accepted Answer · 2018-07-09 05:07:35Z

1

Adding DATE() function in the column will convert it to a valid date format like for the example below!

SELECT DATE(c.enddate) FROM cohort c ORDER BY DATE(c.enddate) DESC LIMIT 1

answered Jul 9, 2018 at 5:07

bdalina

5211 gold badge12 silver badges20 bronze badges

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

1 Comment

J.Pei Over a year ago

Thanks for all of your answers, yes, simply add DATE() works

Riajul Islam · Accepted Answer · 2018-07-09 05:08:45Z

1

Try SELECT DATE(c.enddate) FROM cohort c ORDER BY c.enddate DESC LIMIT 1,

answered Jul 9, 2018 at 5:08

Riajul Islam

1,49315 silver badges19 bronze badges

Comments

Zain Farooq · Accepted Answer · 2018-07-09 06:19:12Z

1

Try this one

SELECT DATE_FORMAT(c.enddate,"%Y-%m-%d") FROM cohort c ORDER BY c.enddate DESC LIMIT 1

The DATE_FORMAT() function formats a date as specified by a format mask.

edited Jul 9, 2018 at 6:19

answered Jul 9, 2018 at 6:04

Zain Farooq

2,9664 gold badges23 silver badges49 bronze badges

Collectives™ on Stack Overflow

php fetch date column from database

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related