Re: last_day(x)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 06 Apr 2001 06:40:55 +0200
Message-ID: <m4iqctc82qkcbfq63mqrtjknjlkm7hsjbc@4ax.com>

On Thu, 5 Apr 2001 19:25:41 -0500, "nyu" <nyu_at_genomicfx.com> 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!
>

Sure you need to quote the date eh
last_day('05-apr-01')

Please try to consult a manaul before asking syntax questions!

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Apr 05 2001 - 23:40:55 CDT