database - how to format date in "YYYY-mm-dd" format using hql? -
when use ms sql database, convert date in timestamp "yyyy-mm-dd" format.
convert(date, "timestamp")
i need same function using hql.
which function remove time indices , give date in "yyyy-mm-dd" format?
you use following converts date string specified format
to_char(mydate,'yyyy-mm-dd')
Comments
Post a Comment