Re^2: MySQL datetime

am confused with this example, tho i want to compare from current to last update time like this way without using sub

use strict;
use warnings;

use Time::Piece;
use Time::Seconds qw/ ONE_DAY /;

my $last_update = ('2025-06-30 14:40:26');
my current_date = localtime;

if ($last_update < 20) {
print "20 days havent passed\n";
}
else {
  print "20 days have passed\n";
}
[download]

Comment on Re^2: MySQL datetime Download Code

Replies are listed 'Best First'.
Re^3: MySQL datetime by hippo (Archbishop) on Jul 01, 2025 at 14:58 UTC
Just construct $dayssince like I have done in the sub (you don't need a sub) and then compare that to the threshold of 20 in your code, rather than $last_update. 🦛	[reply]
Re^4: MySQL datetime by joyfedl (Acolyte) on Jul 01, 2025 at 15:21 UTC
Thanks so much, i got it working like the way you have advised me `use strict; use warnings; use Time::Piece; use Time::Seconds qw/ ONE_DAY /; my $stamp = ('2025-06-30 14:40:26'); my $tp = Time::Piece->strptime (substr ($stamp, 0, 10), '%Y-%m-%d'); my $dayssince = (localtime() - $tp) / ONE_DAY; if ($dayssince < 20) { print "20 days havent passed\n"; } else { print "20 days have passed\n"; }` [download]	[reply] [d/l]