Changeset 2031 for trunk/LATMOS-Accounts/lib
- Timestamp:
- 05/09/17 16:24:15 (7 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm
r2030 r2031 1331 1331 my $sth = $self->base->db->prepare_cached( 1332 1332 q{ 1333 select name from employment where firstday > ? and "user" = ?1333 select name from employment where firstday > ?::timestamp and "user" = ? 1334 1334 order by firstday asc 1335 1335 limit 1 … … 1359 1359 q{ 1360 1360 select name from employment where 1361 (lastday is not null and lastday <= ? - '1 days'::interval) and "user" = ?1361 (lastday is not null and lastday <= ?::timestamp - '1 days'::interval) and "user" = ? 1362 1362 order by firstday desc 1363 1363 limit 1
Note: See TracChangeset
for help on using the changeset viewer.