Postgres Pro
Downloads
Home   >   mailing lists

Re: No to_days format in postgresql? - Mailing list pgsql-php

From Christopher Kings-Lynne
Subject Re: No to_days format in postgresql?
Date
Msg-id 4118803E.9080307@familyhealth.com.au
Whole thread Raw
In response to No to_days format in postgresql?  (azah azah <izza76@gmail.com>)
List pgsql-php
Tree view 
> 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

pgsql-php by date:

Previous
From: azah azah
Date:
Subject: No to_days format in postgresql?
Next
From: Thom Dyson
Date:
Subject: Anyone using Achievo Tool Kit?