Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of manjula.kutty@gmail.com
 designates 64.233.184.239 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding;
        b=o5EieZk8UCh+/QyiB+5NF1FxSKaowIoZfhq7Wo0FvQO4NE43R34TST9UHqUmjFSoZ3kwNzt31oRIlelAHrWuStV5Dl5cubUFRzQ3R9w3u7YEYMdy0O1IqPkd98GpJ4jR5w0+eGnCowuN7zUGXV2eYCk5suu044PCCZroAeTS8Hw=
Message-ID: <4489D117.6000908@gmail.com>
Date: Fri, 09 Jun 2006 12:50:47 -0700
From: Manjula G Kutty <manjula.kutty@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.7.5) Gecko/20041217
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: equal query for derby  " select  sysdate  from dual in oracle"
References: <20060609183002.19410.qmail@web36507.mail.mud.yahoo.com>
In-Reply-To: <20060609183002.19410.qmail@web36507.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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