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
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 (CURRENT_DATE -