Wierd date() output

[foreverhex]

Ok so Ive have never used the date() function before untill now. I thought I had it all down (simple it seemed) but some how I getting something weird.

[code]$signupdate = date("F d Y" , $row["signupdate"]);
$lastlogin = date("F d Y" , $row["lastlogin"]);[/code]

The $row["signupdate"] and $row["lastlogin"] are from a MySQL query and it out put something like this normally: 2006-07-12 23:28:57.

But when I load the page it comes out as: December 31 1969. ???? Why, what, no! Any ideas?

[BillyBoB]

i think its because the date() functions have diff things like for the dates and stuff i will get u the right form brb

[redarrow]

Are you trying to get rid of the time in the $row
if so use str_replace or eregi_repalce or substr

[BillyBoB]

http://us2.php.net/date

thats the page with all the date forms and stuff u have the "F" which displays the word form

[BillyBoB]

did this help u?

[kenrbnsn]

The date() function is expecting a UNIX timestamp as the second parameter, not a string. A UNIX timestamp is the number of seconds since 1-1-1970 for the date. To get this number you can use the strtotime() function. So in your case:
[code]<?php
$signupdate = date("F d Y" , strtotime($row["signupdate"]));
$lastlogin = date("F d Y" , strtotime($row["lastlogin"]));
?>[/code]

Ken

[foreverhex]

Cool thx kenrbnsn. That what it was. Thank you alot!

[akitchin]

an alternative is to pull the date using MySQL's UNIX_TIMESTAMP() function directly.

[ShogunWarrior]

Yeah, e.g: "SELECT UNIX_TIMESTAMP(date) as timestamp"