Re: No to_days format in postgresql?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: azah azah <izza76(at)gmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: No to_days format in postgresql?
Date: 2004-08-10 07:58:54
Message-ID: 4118803E.9080307@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

> 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

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Thom Dyson 2004-08-10 13:24:39 Anyone using Achievo Tool Kit?
Previous Message azah azah 2004-08-10 07:44:37 No to_days format in postgresql?