pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedNo to_days format in postgresql?
2+ messages / 2 participants
[nested] [flat]
* No to_days format in postgresql?
@ 2004-08-10 07:44 azah azah <izza76@gmail.com>
2004-08-10 07:58 ` Re: No to_days format in postgresql? Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 1 reply; 2+ messages in thread
From: azah azah @ 2004-08-10 07:44 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: No to_days format in postgresql?
2004-08-10 07:44 No to_days format in postgresql? azah azah <izza76@gmail.com>
@ 2004-08-10 07:58 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 0 replies; 2+ messages in thread
From: Christopher Kings-Lynne @ 2004-08-10 07:58 UTC (permalink / raw)
To: azah azah <izza76@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-08-10 07:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-10 07:44 No to_days format in postgresql? azah azah <izza76@gmail.com>
2004-08-10 07:58 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox