On Wed, Sep 14, 2016 at 4:49 AM, Patrick B wrote:
>
>
> 2016-09-14 13:17 GMT+12:00 David Rowley :
>
>> On 14 September 2016 at 12:20, Patrick B
>> wrote:
>> > I want to select all rows that have been modified from now to 4 months
>> ago.
>> >
>> > I've used these queries:
>> >
>> >> select
>> >>
2016-09-14 13:17 GMT+12:00 David Rowley :
> On 14 September 2016 at 12:20, Patrick B wrote:
> > I want to select all rows that have been modified from now to 4 months
> ago.
> >
> > I've used these queries:
> >
> >> select
> >> modified_date,
> >> from
> >> clients
> >> WHERE
> >>
On 14 September 2016 at 12:20, Patrick B wrote:
> I want to select all rows that have been modified from now to 4 months ago.
>
> I've used these queries:
>
>> select
>> modified_date,
>> from
>> clients
>> WHERE
>> modified_date BETWEEN '2016-06-13' AND '2016-09-13'
>
Going by my
On 9/13/16, Patrick B wrote:
> Hi guys,
>
> I got the following column:
>
> modified_date TIMESTAMP(6) WITHOUT TIME ZONE DEFAULT
>> "statement_timestamp"(),
>
>
> I want to select all rows that have been modified from now to 4 months ago.
>
> I've used these queries:
>
> select
>> modified
On 09/13/2016 05:20 PM, Patrick B wrote:
Hi guys,
I got the following column:
modified_date TIMESTAMP(6) WITHOUT TIME ZONE DEFAULT
"statement_timestamp"(),
I want to select all rows that have been modified from now to 4 months ago.
I've used these queries:
select
mod
> I tried this but, got the following:
>
> ---
> mytest=> select fagentname from feedback where ftdate between
> now()::date and
> mytest-> (now()::datetime - '@ 7 days'::timespan)::date;
> ERROR: function date(timestamp) does not exist
> -
I tried this but, got the following:
---
mytest=> select fagentname from feedback where ftdate between now()::date and
mytest-> (now()::datetime - '@ 7 days'::timespan)::date;
ERROR: function date(timestamp) does not exist
-
