Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: domain of pravinrane32@gmail.com
 designates 64.233.162.227 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:from:to:references:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:x-mimeole:in-reply-to;
        b=Td44QtUH/kX6ivr+myWHfa9yvUIAyXIG10+Pe8WHK22O4pC07i4Y5/5CbQkocxPhYsY6VBukj1H0q7JODj2g257TgnGwhZhh8EeMud+SwiMe0NNk4zmgQmS0hl8cd9jYAr6R2Yd2yodZyxvYLlErMyqlKWwWUNXjxIyyoUfRKtM=
From: "Pravin Rane" <pravinrane32@gmail.com>
To: <user-java@ibatis.apache.org>,
	<ralf.assmann@innovations.de>
References: <46822195.5030700@innovations.de>
 <95A15C4363D79944971A2D1CB36F5D49023128D2@APAXM2103.dir.svc.accenture.com>
Subject: RE: How to use system date
Date: Wed, 27 Jun 2007 15:27:09 +0530
Message-ID: <010001c7b8a1$89c4a5c0$182d4d0a@persistent.co.in>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
thread-index: Ace4lnwbfAy2FV4eRBCrSG3/u/gesQAAEJPAAAJy3sA=
In-Reply-To: 
 <95A15C4363D79944971A2D1CB36F5D49023128D2@APAXM2103.dir.svc.accenture.com>

Hi Bharathi,

I am not sure how good this solution is but you can convert date to
'dd-mm-yyyy' character representation and then compare it with query
parameter. This will return the desired result set.

Regards
~Pravin

-----Original Message-----
From: bharathi.mani@accenture.com [mailto:bharathi.mani@accenture.com] 
Sent: Wednesday, June 27, 2007 2:13 PM
To: ralf.assmann@innovations.de; user-java@ibatis.apache.org
Subject: RE: How to use system date

Can I use to_date(sysdate, 'dd-mm-yyyy') to remove the precision for
time of the day? Cos I have a value in db "27-JUN-2007'. But when I pass
to_date(sysdate, 'dd-mm-yyyy') to my select query in iBatis, it does not
return any value.
Any help in this will be great.
Thanks

-----Original Message-----
From: Ralf Assmann [mailto:ralf.assmann@innovations.de] 
Sent: Wednesday, June 27, 2007 2:07 PM
To: Mani, Bharathi
Subject: Re: How to use system date


Depending on your database, you can use the database' date, e.g. for a
db2:

"select * from test where date = current date"

The should be similar functions for other databases. Alternatively, make

a java.sql.Date using System.currentTimeMillis() and pass this
attribute.


Ralf Assmann

-------------------------------------------------------------------
Ralf Assmann, Dipl.-Ing. (FH)
Innovations Softwaretechnologie GmbH
Ziegelei 7, 88090 Immenstaad, Germany
Tel.: +49 7545 202-324
Tel.: +49 7545 202-300 (Zentrale)
Fax.: +49 7545 202-301
Email: ralf.assmann@innovations.de
Web: http://www.innovations.de
-------------------------------------------------------------------
Geschaeftsfuehrung: 
Achim Berger, Thomas Cotic, Walter Pitz
Reg.-Gericht Ulm HRB 631622
-------------------------------------------------------------------


bharathi.mani@accenture.com schrieb:
>
> Hi,
>
> How can I pass current system date to a select query in iBatis?
>
> 'Select * from test where data = sysdate'. Will this work?
>
> Thanks,
>
> Bharathi
>
> This message is for the designated recipient only and may contain 
> privileged, proprietary, or otherwise private information. If you have

> received it in error, please notify the sender immediately and delete 
> the original. Any other use of the email by you is prohibited.
>


This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information.  If you have
received it in error, please notify the sender immediately and delete the
original.  Any other use of the email by you is prohibited.