SELECT s.*
FROM $s_table s
JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner)
- WHERE CURRENT_DATE BETWEEN s.start_date AND s.end_date
+ WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date
SQL
my $sth = action::survey->db_Main->prepare_cached($select);
SELECT s.*
FROM $s_table s
JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner)
- WHERE CURRENT_DATE BETWEEN s.start_date AND s.end_date
+ WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date
AND s.opac IS TRUE;
SQL
SELECT s.*
FROM $s_table s
JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner)
- WHERE CURRENT_DATE BETWEEN s.start_date AND s.end_date
+ WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date
AND s.required IS FALSE;
SQL
SELECT s.*
FROM $s_table s
JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner)
- WHERE CURRENT_DATE BETWEEN s.start_date AND s.end_date
+ WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date
AND s.required IS TRUE;
SQL
SELECT s.*
FROM $s_table s
JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner)
- WHERE CURRENT_DATE BETWEEN s.start_date AND s.end_date
+ WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date
AND s.usr_summary IS TRUE;
SQL