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ť
MENU
Hore