X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=src%2FModules%2FCountdown.pl;h=a5e9edffcaa9873a01566039814290f5912d62aa;hb=f7cae48a17d6decd0a9bd997188271daa0a885b1;hp=5a11948a0447514ecbe14a76c31552ba5e18f103;hpb=93eb520d8e5ebbdea3a20029d9d95e0d4e848901;p=infobot.git diff --git a/src/Modules/Countdown.pl b/src/Modules/Countdown.pl index 5a11948..a5e9edf 100644 --- a/src/Modules/Countdown.pl +++ b/src/Modules/Countdown.pl @@ -50,7 +50,7 @@ sub Countdown { $monname = (&sqlRawReturn("SELECT MONTHNAME('$sqldate')"))[0]; } elsif ($param{'DBType'} =~ /^pgsql$/i) { - $to_days = (&sqlRawReturn("SELECT date_trunc('day', + $to_days = (&sqlRawReturn("SELECT date_trunc('day', 'now'::timestamp - '$sqldate')"))[0]; $dayname = qw(Sun Mon Tue Wed Thu Fri Sat)[(&sqlRawReturn("SELECT extract(dow from timestamp '$sqldate')"))[0]]; $monname = qw(BAD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec)[(&sqlRawReturn("SELECT extract(month from timestamp '$sqldate')"))[0]];