db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Graham Leggett <minf...@sharp.fm>
Subject Best practise: Querying Dates in Criteria
Date Thu, 20 Apr 2006 20:55:35 GMT
Hi all,

I need to create a query between two dates.

Apparently I need to use the Criteria.addDate() convenience method, 
followed by a Criteria.Criterion object.

The problem is that no convenience method exists to handle Date 
Criterion's, which means I need to format the date as a String before 
passing it to Torque.

What is the best practise Date format that I should use that Torque will 
understand across all databases?

The comparisons are of Dates, not Date+Time, so I need a format that 
does not include a timezone.

Regards,
Graham
--

Mime
View raw message