Skip to main content
F
future-architect
Known Participant
March 18, 2012
Question

php long error

  • March 18, 2012
  • 1 reply
  • 944 views

I have the following code and input, and am getting this error:

code:

$date = date('D, d M Y H:i:s', $date);

input:

1332092255

error:

Warning:  date() expects parameter 2 to be long, string given in (page) on line 72

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
March 19, 2012

What is the value in $date before calling the date() function? Where is it coming from? Is it a string or int?

F
future-architectAuthor
Known Participant
March 19, 2012

the value is 1332092255.  it comes from mysql database.  i have it listed as varchar there.  not sure that that should affect it though. 

B
bregent
Participating Frequently
March 19, 2012

what about BIGINT?

and what does "unsigned" mean?  does it mean, no set value length?


It should not need to be as big as a BIGINT. Did you try the casting test I suggested?

Unsigned means that it does not store negative numbers. By default, numeric datatypes are signed, so they support both negative and positive. Unsigned means that only positive values can be stored. As a result, unsigned columns can store twice as many values as signed. Still, given the values of unix time stamp, a signed int should work.

As a troubleshooting measure, try the code I suggested a few posts back.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices