Yes, 1/1/1970 is equal to 'Not set', but I think you have to expect
this to be changed to real NULL as I have very strong wish to change
it as NULLs are clearer, easier for development and more flexible.
Hope we'll have time to do it before 3.8.0
On 6/19/07, Stephen Turner <[EMAIL PROTECTED]> 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".
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
--
Best regards, Ruslan.
_______________________________________________
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
