[rt-users] Question about Dates in DB

Stephen Turner sturner at MIT.EDU
Tue Jun 19 11:31:21 EDT 2007


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 




More information about the rt-users mailing list