Timestamp confusion

[Sul]

Hi,

I have the code below, however it doesn't seem to be converting the timestamp properly. $mytimestamp is in the format YYYYMMDDHHMMSS - the date function does not seem to be converting it correctly.

$mydate= date("D, d M Y G:i:s",strtotime($mytimestamp))

Not sure of what I'm doing incorrectly. Help would be appreciated 🙂

[Weedpacket]

No, strtotime() doesn't know what to do with MySQL timestamps. MySQL does, though, and it has a DATE_FORMAT function to convert it. Use that if you can; otherwise you'll have to mess with [man]substr[/man] or [man]sscanf[/man], and [man]mktime[/man].

[Sul]

Thanks, that works! 🙂