Changeset 2031

Timestamp:

05/09/17 16:24:15 (7 years ago)

Author:

nanardon

Message:

Fix sql queries

File:

• trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm (modified) (2 diffs)

trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm

@@ -1331 +1331 @@
                     my $sth = $self->base->db->prepare_cached(
                         q{
-                        select name from employment where firstday > ? and "user" = ?
+                        select name from employment where firstday > ?::timestamp and "user" = ?
                         order by firstday asc
                         limit 1
@@ -1359 +1359 @@
                         q{
                         select name from employment where
-                        (lastday is not null and lastday <= ? - '1 days'::interval) and "user" = ?
+                        (lastday is not null and lastday <= ?::timestamp - '1 days'::interval) and "user" = ?
                         order by firstday desc
                         limit 1