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

Hi !

Nope, I tried it before, but it seems that "IS NULL" is different from "=
{ts '00-00....}".
By the way, the deprecated new Date(0, 0, 0, 0, 0, 0) corresponds to "{ts
'1899-12-31 00:00:00.0'}" on my env.
I could also build a custome crit like dateCrit.add(TestPeer.EXPIRES,
(Object)"={ts '0000-00-00 00:00:00.0'}", Criteria.CUSTOM) but I don't think
this is generic enough ... maybe some databases work with another timestamp
format (I use Derby here).

Maybe that is because my schema doesn't NULL the value correctly ? Here is
the column definition :
<column name="expires"
      type="TIMESTAMP"
      required="false" />
And the generated SQL:
expiration TIMESTAMP,

Any idea ?


On Thu, Aug 7, 2008 at 12:38, Hidde Boonstra [Us Media] <
[email protected]> wrote:

> 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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>


-- 
Pierre.
Some people, when confronted with a problem, think "I know, I'll use XML".
Now they have two problems. -- Jamie Zawinski / James Robertson