Skip site navigation (1) Skip section navigation (2)

No to_days format in postgresql?

From: azah azah <izza76(at)gmail(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: No to_days format in postgresql?
Date: 2004-08-10 07:44:37
Message-ID: 235b1a280408100044251eca07@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-php
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

Responses

pgsql-php by date

Next:From: Christopher Kings-LynneDate: 2004-08-10 07:58:54
Subject: Re: No to_days format in postgresql?
Previous:From: Justin WyerDate: 2004-08-08 13:20:10
Subject: Re: pg calls not working from within Apache

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group