timestamp to date in php

[crawfd]

I really can't make sense into this to see why it's not working. I've looked at other examples on the net but I still get a weird date. I'm retreiving my date from a column called date llogin which is a datetime column which I'm storing using Date("Y-m-d H:i:s")

I have the following:

<?=date("d-m-Y", strftime($a1[llogin]));?>

But it's giving me this date.........

31-12-1969

Thanks

[Chemist]

31-12-1969 is the day prior to the Unix Epoch (January 1 1970). You got an error some place. If all you need is day month and year why use strftime? Also, what is the value of $a1[llogin] ? To use strftime I think you you need $a1[llogin] to evaluate to a timestamp.

Try something along the lines of

date("d-m-Y", strtotime($a1[llogin]))

assuming $a1[llogin] is valid

Don

[bradgrafelman]

Why even select the date in Y-m-d format in the first place? If you want d-m-Y, make SQL convert its data before PHP even touches it: DATE_FORMAT().