Thread: No to_days format in postgresql?

No to_days format in postgresql?

From
azah azah
Date:
Hi,
I really need help to convert to_days from mysql to postgresql as below:

TO_DAYS(now()) - TO_DAYS(timecheck) <=7

how can i do it in postgresql?

Tq

Re: No to_days format in postgresql?

From
Christopher Kings-Lynne
Date:
> I really need help to convert to_days from mysql to postgresql as below:
>
> TO_DAYS(now()) - TO_DAYS(timecheck) <=7
>
> how can i do it in postgresql?

(timecheck - interval '7 days') <= current_timestamp

Chris