Hi everybody,

I have to extract just the date (without the hour) from a field of the database.
I think I should use trunc(), don't I?
I've tried trunc(dt, 'dd/MM/yyyy') but it did not work, resulting in an WARN RequestProcessor:516 - Unhandled Exception thrown: class org.hibernate.exception.SQLGrammarException

Can anybody help me to solve this?

thanks, Guilherme

what database? I think not all TRUNCs are the same. Here's an Oracle example:
TRUNC(SYSDATE)
...returns current date at (preceding) midnight. Their format strings are 'DD', or 'YEAR', etc.
TRUNC(SYSDATE,'YEAR')

If you're using something else, just google "sql trunc" and your database name.

--------------------
pls rate if helpful!