[rt-users] What’s the correct SQL syntax for a date/time custom field that’s not set?

Alex Vandiver alexmv at bestpractical.com
Wed Nov 20 14:29:04 EST 2013


On Wed, 2013-11-20 at 11:13 -0800, Landon Stewart wrote:

> Is using > "1970-01-01 00:00:00” the only way?

Currently, yes.

> Seems like that definite value might be begging for bugs or something
> if somehow the unset date equals "1970-01-01 05:00:00” for some reason
> down the road.  I just want to make sure I’m not setting myself up for
> buggy behaviour in the future.

That magic date is the "UNIX epoch," and will not change.
 - Alex





More information about the rt-users mailing list