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/