Posted by hph on 04/26/06 05:05

Okay, another trivial matter that I can't solve.

I have a variable - $lastdate - that is the latest date any record in a
MySQL database was updated. Its MySQL format is TIMESTAMP.

If I say [echo $lastdate] I get the output I'd expect - 20060424221549
which is a YYYYMMDDHHMMSS format.

I'd like to be able to display that using a format of mm/dd/yy with no
leading spaces on the month and day. I don't know what the php command
is to do this. In other words, I'm trying to display a variable -
$lastdate - formatted a certain way. I know that the formatting string
n/j/y will get my output looking as I'd like, but I can't figure out how
to apply that to my variable.

Thanks to those who've helped me with my questions the last two days.
This seems to be the last piece of information I can't find right now.

• Next in forum: Re: noob question - integer output format, use of SUM in MySql
• Prev in forum: Re: mysql and mail() function
• Thread view: More noob nonsense - output format for a timestamp date variable

[Reply to this message]