last_day(x)

From: nyu <nyu_at_genomicfx.com>
Date: Thu, 5 Apr 2001 19:25:41 -0500
Message-ID: <3acd0cc9$0$63446$736b3e2@news2.twtelecom.net>

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 Thu Apr 05 2001 - 19:25:41 CDT