db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: to_char(sysdate,'YYYYMMDD')
Date Thu, 05 Aug 2010 14:38:27 GMT
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
>
>  
>
>  
>


Mime
View raw message