Re: equal query for derby " select sysdate from dual in oracle"

[Manjula G Kutty]

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