jill han wrote:
Below is a piece of code to get records from a table and exception
// startDate and endDate are Date object
// aDate has Date data type in oracle db
String sql = "Select * from aTable ";
sql = sql + " Where aDate ";
sql = sql + " Between '" + startDate + "' And '" + endDate + "'
age-
> From: Dave Newton [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 09, 2005 10:22 AM
> To: Apache Torque Users List
> Subject: Re: how to write a query with Date type
>
> jill han wrote:
>
> >Below is a piece of code to get records from a table and excepti
ectColumn("Round(Avg(" + aTablePeer.aColumn + "), 2)")
-Original Message-
From: Dave Newton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 10:22 AM
To: Apache Torque Users List
Subject: Re: how to write a query with Date type
jill han wrote:
>Below is a piece of cod
jill han wrote:
Below is a piece of code to get records from a table and exception
// startDate and endDate are Date object
// aDate has Date data type in oracle db
String sql = "Select * from aTable ";
sql = sql + " Where aDate ";
sql = sql + " Between '" + startDate + "' And '" + endDate + "'
Below is a piece of code to get records from a table and exception
// startDate and endDate are Date object
// aDate has Date data type in oracle db
String sql = "Select * from aTable ";
sql = sql + " Where aDate ";
sql = sql + " Between '" + startDate + "' And '" + endDate + "' ";
List sqlResult =
