How to format date in Hibernate HQL?

hi,

I am using Hibernate in my Spring Java app and I have an object Event with a field eventDate of type Date.

What are my options for formatting a date to a string using the YYYY-MM-DD format? I guess I could retrieve the field as a date, and then format the date in Java, but that's probably not too efficient.

My app is currently setup to work with a MySQL database, but I would also like it to work on Postgresql.

thanks in advance!

from Programming https://ift.tt/2JTtU6Y
via IFTTT