db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manjula G Kutty <manjula.ku...@gmail.com>
Subject Re: equal query for derby " select sysdate from dual in oracle"
Date Fri, 09 Jun 2006 19:50:47 GMT
vijayan k wrote:

> Hi,
>  
> I like to get the system date from the derby SQL statment.
> in oracle we have default table "dual" here
> if we write query as "select sysdate from dual" w'll get the system date.
>  
> i need like this in derby
>  
> Please help me out ASAP
>  
> Thanks
>  
> Vijayan.gk
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
Hi,

I don't know much about oracle. But in derby if you give the following 
command

VALUES CURRENT_TIMESTAMP

you will get the current system time.

For further reference please visit this link 
http://db.apache.org/derby/docs/dev/ref/rrefjdbc88908.html

Thanks
Manjula

Mime
View raw message