On Tue, Nov 23, 2004 at 09:03:26AM -0500, John DeSoi wrote: > select now() - ((round(random()*45))::text || ' days')::interval;
Or one of the following (add round() if desired): select now() - 45 * random() * interval'1 day'; select now() - random() * interval'45 day'; -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
