Hi for all. I'm using Cache 4.1. I'm trying to compare a field timestamp with a value date using sql. ValueDate = 2004-02-02 in date format, It's a stored procedure parameter.
select * from tabela where DateTimeField < ValueDate + '23:59:59' I tried it using CONVERT, but it don't work for me. Can anyone help me? Thanks in advance. Mauricio.
