Select legenda, imagem1, texto, data,titulo from conteudo where data < now() and ordem='1' and coditem = '196' order by date(data) desc &erro=ERROR: operator does not exist: text < timestamp with time zone LINE 1: ...m1, texto, data,titulo from conteudo where data < now() an... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.