From 6a490c8c2c7c60e5530ace67fb5e526575939849 Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Sat, 27 Dec 2008 11:03:18 +0100
Subject: Fix for vndb-date-bug-thingy

VNDB::* code uses UTC for everything, while PgSQL uses the server
local time zone by default.

update_vncache() has this same bug and should actually be fixed as
well... but it's not that important. :-)
---
 lib/VNDB/DB/Releases.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/lib/VNDB/DB/Releases.pm b/lib/VNDB/DB/Releases.pm
index b2c78d5e..6af2f736 100644
--- a/lib/VNDB/DB/Releases.pm
+++ b/lib/VNDB/DB/Releases.pm
@@ -3,6 +3,7 @@ package VNDB::DB::Releases;
 
 use strict;
 use warnings;
+use POSIX 'strftime';
 use Exporter 'import';
 
 our @EXPORT = qw|dbReleaseGet dbReleaseAdd dbReleaseEdit|;
@@ -27,7 +28,7 @@ sub dbReleaseGet {
     $o{vid} ? (
       'rv.vid = ?' => $o{vid} ) : (),
     defined $o{unreleased} ? (
-      q|rr.released !s TO_CHAR('today'::timestamp, 'YYYYMMDD')::integer| => $o{unreleased} ? '>' : '<=' ) : (),
+      q|rr.released !s ?| => [ $o{unreleased} ? '>' : '<=', strftime('%Y%m%d', gmtime) ] ) : (),
   );
 
   my @join = (
-- 
cgit v1.2.3