Laravel overflow when updating value

Question

The problem I encountered was I have a column named "timeStart" to store the unix epoch time in millisecond. When I was updating through Laravel update function, the value stored in database shows that it's negative instead of the value I wanted it to store.

e.g. value intended to store: 1540090500000 value stored in database: -1802759264

I'm using bigint datatype here. The same code works on my localhost database but not when I uploaded it onto my shared hosting server, which is a weird issue. What can be done to address this issue?

The value you're converting to epoch is probably a date before 1 jan 1970 — Clément Baconnier, Nov 09 '18 at 08:09
@cbaconnier I converted the time input using strtotime and I checked the output which is correct as well, I was thinking whether it's the problem for datatype, as if I put 1540090500 (second) instead of millisecond, it works perfectly. However, my main problem right now is on my localhost, it was able to store the millisecond format, but on my server, it wasn't able to do so. — jiale1029, Nov 09 '18 at 09:12
If I put 64bit, it returns me an error saying that out of range value — jiale1029, Nov 09 '18 at 09:40

score 2 · Answer 1 · answered Nov 09 '18 at 09:49

So how can I understod you are using different mysql services . So to learn more abount 32/64bit based bigint please follow 32/64bit os BIGINT

Also I will suggest you to use string instead of bigint. Some os/operations sometimes conflicts due to type bigint

Laravel overflow when updating value

1 Answers1