Hi Mamatha,You can write your own formatting function to handle this issue. Please see http://db.apache.org/derby/docs/10.6/ref/ref-single.html#crefsqlj95081
Hope this helps, -Rick Mamatha Kodigehalli Venkatesh wrote:
Hi all,I see that we have the "CHAR" method - but I was more looking for a * function * like the Oracle "to_char".to_char(sysdate,'YYYYMMDD')Is there an equivalent in derby...I am aware of CURRENT_DATE.. But I need to format this.Thanks Mamatha
