Re: last_day(x)

From: Steve Bell <swayne.bell_at_sympatico.ca>
Date: Fri, 06 Apr 2001 11:54:45 GMT
Message-ID: <3ACDABB7.F038D55C@sympatico.ca>

Hi,
just put single quotes around the date..

select last_day('05-APR-01') from dual;

Regards,
Steve

nyu wrote:

> Hi, I'm using
>
> SQL*Plus: Release 8.0.6.0.0 - Production on Thu Apr 5 19:19:23 2001
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> When I try the following:
>
> SQL>select last_day(05-APR-01) from dual;
> *
> ERROR at line 1:
> ORA-00904: invalid column name
>
> Same error occurs to other functions like add_months(x,y).
>
> Can anyone tells me why?
>
> Thanks in advance!
Received on Fri Apr 06 2001 - 06:54:45 CDT