Re: No to_days format in postgresql?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: azah azah <izza76@xxxxxxxxx>
Subject: Re: No to_days format in postgresql?
From: Christopher Kings-Lynne <chriskl@xxxxxxxxxxxxxxxxxxx>
Date: Tue, 10 Aug 2004 15:58:54 +0800
Cc: pgsql-php@xxxxxxxxxxxxxx
In-reply-to: <235b1a280408100044251eca07@xxxxxxxxxxxxxx>
References: <235b1a280408100044251eca07@xxxxxxxxxxxxxx>
User-agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)

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

References:
- No to_days format in postgresql?
  - From: azah azah

Prev by Date: No to_days format in postgresql?
Next by Date: Anyone using Achievo Tool Kit?
Previous by thread: No to_days format in postgresql?
Next by thread: Anyone using Achievo Tool Kit?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql General] [Postgresql Admin] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Backpacking] [Postgresql Jobs]

Powered by Linux