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:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 8:31 AM To: Justin Brodley; rt-users@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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com