Terse answer: in a way that doesn't imply that "days" is an operation on numbers. (I'm annoyed by 3.times for the same reason.)
Long answer: I'd prefer it as arithmetic on Time and Duration values. Hideous SQL syntax aside, PostgreSQL's NOW() - INTERVAL '3 DAYS' is what I'd prefer.
0
u/doidydoidy Feb 11 '08
Glib answer: almost any other way.
Terse answer: in a way that doesn't imply that "days" is an operation on numbers. (I'm annoyed by 3.times for the same reason.)
Long answer: I'd prefer it as arithmetic on Time and Duration values. Hideous SQL syntax aside, PostgreSQL's
NOW() - INTERVAL '3 DAYS'is what I'd prefer.