Re: SQL TIMESTAMP and Torque java.util.Date mapping.

Hi,

criteria.add(TestPeer.EXPIRES, (Object) null, Criteria.ISNULL)

doesn't work?

Regards,

Shinkan wrote:
> Hi again there !
> 
> I have a TIMESTAMP type column in a schema, and the Torque maps it to
> java.util.Date, which is really convenient most of the time.
> BUT, I would like to check for this column nullity, SQL point-of-view.
> That's to say, I have to check that this field, let's call it "expires", is
> NULL Timestamp (00-00-0000 00:00:00).
> Trying to compare expires against new Date(0) fails as new Date(0) gives
> (and that's obvious), the first UNIX timestamp date.
> I can use New Date(int, int, int, int, int, int) BUT it is deprecated, and I
> really would like to avoid this.
> 
> So, how can I build a Criteria to check if my field "expires" from table
> "test" is NULL timestamp (00-00-0000 00:00:00) ?
> timeCrit.add( TestPeer.EXPIRES, ?????????);
> 
> Thanks in advance !
> 

-- 
Hidde Boonstra
Us Media B.V.
Stadhouderskade 115
1073 AX Amsterdam

t: 020 428 68 68
f: 020 470 69 05
www.usmedia.nl