[rt-users] Question about Dates in DB

Gene LeDuc gleduc at mail.sdsu.edu
Tue Jun 19 11:43:03 EDT 2007

FWIW, a brief snoop didn't turn up any null date fields in our MySQL RT 


At 08:31 AM 6/19/2007, Stephen Turner wrote:
>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".
>Community help: http://wiki.bestpractical.com
>Commercial support: sales at bestpractical.com
>Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a 
>copy at http://rtbook.bestpractical.com

Gene LeDuc, GSEC
Security Analyst
San Diego State University 

More information about the rt-users mailing list