jvsrvcs wrote
> I tried that but get an error
> v_start_date date;
> v_minus_one_year date;
>
> I have v_start_date to start with and want to subtract one year and put
> into v_minus_one_year
>
> select v_start_date - interval '1 yr' as v_minus_one_year;
>
>
>
> --- I get:
>
> ERRO
Jay Vee writes:
> I tried that but get an error
> ? ? v_start_date date;
> ? ? v_minus_one_year date;
>
> I have v_start_date to start with and want to subtract one year and put into
> v_minus_one_year
> ??
> ? select v_start_date - interval '1 yr' as v_minus_one_year;
sj$ cat q
create or repl
I tried that but get an error
v_start_date date;
v_minus_one_year date;
I have v_start_date to start with and want to subtract one year and put
into v_minus_one_year
select v_start_date - interval '1 yr' as v_minus_one_year;
--- I get:
ERROR: query has no destination for result da
On 02/06/2014 09:25 AM, Jay Vee wrote:
I have reviewed working with dates documentation but some things are
not clear and I cannot get an example to work for what I need.
I am passing a date into a stored function like '2013-04-01'
The stored function accepts this string as a date type.
Withi
On 02/06/2014 09:25 AM, Jay Vee wrote:
I have reviewed working with dates documentation but some things are not
clear and I cannot get an example to work for what I need.
I am passing a date into a stored function like '2013-04-01'
The stored function accepts this string as a date type.
Within
