vbulletin time is weird

[sde]

the date field in the vbulletin db is int(10)

i assume this is a unixtimestamp

"1046729556" is an example

i try to convert this to a time, and it doesn't work:

PHP Code:

<?
$this->dateline=date("m-d-Y",$this->dateline);
?>

but it just prints out 12-31-1969

any ideas on this?

[joe_bruin]

12-31-1969 is 0 unix time. you are not passing in the value correctly.

PHP Code:

<?
  echo date("Y-m-d", 1046729556);
?>

i get:
2003-03-03

[sde]

ok, it was not liking the fact that i was using the same variable on the left as i was on the right. it maybe because they were array variables. i just set the initial variable that grabs the dateline into a non-array variable .. and it works great.

thanks for the check.