[SOLVED] Any PHP wizards here? I am trying to figure out if PHP's built in time() and mktime() functions can understand dates beyond 2038?

wh33t · 05-29-2023, 04:27 PM

I've read some things that says on a 64bit machine and 64bit PHP it should be fine to go beyond the 32bit signed barrier, of which my VM meets both criteria (as far as I can tell) and yet my script just halts as soon as I try to get the unix_ts of a 2038 date.

Any tips?

michaelk · 05-29-2023, 05:55 PM

What is the output of this php CLI program? Include shebang and php tags etc...

Code:

$date = '2040-02-01';
$format = 'l d F Y H:i';
$mydate1 = strtotime($date);
echo "date = $date\n";
echo "Feb 1, 2040 is on a " . date("l", mktime(0, 0, 0, 2, 1, 2040))."\n";
echo "Unix timestamp  = $mydate1\n";
echo "$mydate1 time stamp = ".date("$format",$mydate1)."\n";

wh33t · 05-29-2023, 07:10 PM

Quote:

Originally Posted by michaelk

What is the output of this php CLI program? Include shebang and php tags etc...

Code:

$date = '2040-02-01';
$format = 'l d F Y H:i';
$mydate1 = strtotime($date);
echo "date = $date\n";
echo "Feb 1, 2040 is on a " . date("l", mktime(0, 0, 0, 2, 1, 2040))."\n";
echo "Unix timestamp  = $mydate1\n";
echo "$mydate1 time stamp = ".date("$format",$mydate1)."\n";

Code:

date = 2040-02-01
Feb 1, 2040 is on a Wednesday
Unix timestamp  = 2211696000
2211696000 time stamp = Wednesday 01 February 2040 00:00

Huh, I guess that works. I'll have to go figure out why my code is not working then.

wh33t · 05-29-2023, 07:13 PM

Ahh. I'm trying to ram this giant number into a mysql (int), I guess it needs to be a double?

Nope, wrong again, it needs to be a bigint!

Thanks for your help!

michaelk · 05-29-2023, 07:44 PM

mysql signed integers are +/- 2147483647 (January 19, 2038) but unsigned is 0 - 4294967295 (February 7, 2106)
Integers use 4 bytes of storage whereas bigint use 8 bytes of storage if anyone cares...

sundialsvcs · 06-07-2023, 07:56 PM

Instead of using any sort of "int," you should be using MySQL's provided date or datetime column types. Tell MySQL that the data being stored "is what it really is," and it will happily do the heavy lifting for you.

wh33t · 06-07-2023, 08:01 PM

Quote:

Originally Posted by sundialsvcs

Instead of using any sort of "int," you should be using MySQL's provided date or datetime column types. Tell MySQL that the data being stored "is what it really is," and it will happily do the heavy lifting for you.

I know it's an option. I prefer unix timestamps though.

Thanks for the advice though.

chrism01 · 06-08-2023, 12:47 AM

For which you'd use https://www.w3resource.com/mysql/dat...p-function.php .

As per sundialsvcs, use one of the "date types" cols for actual date storage https://dev.mysql.com/doc/refman/8.0/en/datetime.html