You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by Mamatha Kodigehalli Venkatesh <Ma...@ness.com> on 2010/08/05 14:47:44 UTC

to_char(sysdate,'YYYYMMDD')

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

Re: to_char(sysdate,'YYYYMMDD')

Posted by Rick Hillegas <ri...@oracle.com>.

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
>
>  
>
>  
>