Re: [PERFORM] NOW vs CURRENT_DATE

Hi, dforum wrote: Hello every body, I just discover a big not only big huge difference between NOW() and CURRENT_DATE. Did you already know about it and do you know why ? DELETE FROM blacklist where bl_date < (NOW() - interval '2 DAY'); on 6 000 000 of records 699 ms DELETE FROM blacklist

Re: [PERFORM] NOW vs CURRENT_DATE

> I just discover a big not only big huge difference between NOW() and > CURRENT_DATE. > > Did you already know about it and do you know why ? > > DELETE FROM blacklist where bl_date < (NOW() - interval '2 DAY'); > on 6 000 000 of records > 699 ms > > DELETE FROM blacklist where bl_date < (CURR

[PERFORM] NOW vs CURRENT_DATE

Hello every body, I just discover a big not only big huge difference between NOW() and CURRENT_DATE. Did you already know about it and do you know why ? DELETE FROM blacklist where bl_date < (NOW() - interval '2 DAY'); on 6 000 000 of records 699 ms DELETE FROM blacklist where bl_date < (CUR