diff options
| author | Yorhel <git@yorhel.nl> | 2008-12-29 13:42:58 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2008-12-29 13:42:58 +0100 |
| commit | 3c1b01ec2ba0328f74aa7269bae8015cf1faf531 (patch) | |
| tree | 32be3bc4696399abf14e09f1f8f78f38f92509dc /lib/VNDB/DB/Releases.pm | |
| parent | 1ef9db32e893669cc5da7b69b371ef051008b989 (diff) | |
| parent | f000aaf69e345bae4fc5581e5028463c85cfdafb (diff) | |
Merge branch 'beta'2.1
Diffstat (limited to 'lib/VNDB/DB/Releases.pm')
| -rw-r--r-- | lib/VNDB/DB/Releases.pm | 3 |
1 files changed, 2 insertions, 1 deletions
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 = ( |