[rt-users] Question about Dates in DB

[Justin Brodley]

It's nice to see that its consistently inconsistent. We are also running
Oracle, so I'll have to look out for this. 


Justin Brodley
-----Original Message-----
From: Stephen Turner [mailto:sturner at MIT.EDU] 
Sent: Tuesday, June 19, 2007 8:31 AM
To: Justin Brodley; rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Question about Dates in DB

At Tuesday 6/19/2007 11:26 AM, Justin Brodley wrote:
>I'm working on some reports for our RT database, and I'm noticing 
>that fields get populated with 1/1/1970 if there is nothing entered 
>into the DB.
>
>Is this accurate assessment?  If so can I just assume that 1/1/1970 =
null?
>

Yes, that's right. One other twist, if I recall correctly, (it may 
depend on what database you use- we run Oracle) is that sometimes 
null dates are stored as null in the database. So you may have to 
allow for both null and 1/1/1970 as meaning "no date set".

Steve