Re: query

From: Richard Huxton <dev(at)archonet(dot)com>
To: Terry Fielder <terry(at)ashtonwoodshomes(dot)com>
Cc: Chandan_Kumaraiah <Chandan_Kumaraiah(at)satyam(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: query
Date: 2005-03-17 12:02:14
Message-ID: 423971C6.1020706@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Terry Fielder wrote:
> now() returns a timestamp.
>
> Cast it to a date and then you can subtract days. e.g.
>
> select now()::date -1

Or CURRENT_DATE - 1

>>
>> *In oracle we write sysdate-1*
>>
>> *For example,we write a query (select * from table1 where
>> created_date>=sysdate-1).Whats its equivalent in postgre?*

--
Richard Huxton
Archonet Ltd

In response to

  • Re: query at 2005-03-17 11:43:29 from Terry Fielder

Browse pgsql-sql by date

  From Date Subject
Next Message Kenneth Gonsalves 2005-03-17 12:31:19 Re: Query performance problem
Previous Message Terry Fielder 2005-03-17 11:43:29 Re: query