No to_days format in postgresql?

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: No to_days format in postgresql?

> 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings