pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
No 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