SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type date: ""
CONTEXT: unnamed portal parameter $2 = '', query was:
SELECT
l.*
,la.author
,ls.scope
,lt.law_type_name
,lt.url AS law_type_url
,CASE
WHEN l.effective_from <= 'now'::TEXT::DATE AND (l.effective_to >= 'now'::TEXT::DATE OR l.effective_to IS NULL) THEN 1
ELSE 0
END AS is_current_valid
FROM
law l
INNER JOIN law_c_author la ON (la.author_id = l.author_id)
LEFT OUTER JOIN law_c_scope ls ON (ls.scope_id = l.scope_id)
INNER JOIN law_c_type lt ON (lt.law_type = l.law_type)
WHERE
law_nr = :law_nr
AND source = 'SLOVLEX'
AND effective_from <= :effective_from
AND (effective_to >= :effective_to OR effective_to IS NULL)
AND l.law_type IN ('ZAKON','BEZ_TYPU','REK_ZAKON')
ORDER BY
effective_from DESC
LIMIT 1
Daný predpis nebolo možné vyhladať
Daný predpis nebolo možné vyhladať