Re: last_day(x)

From: Actiris <actiris_at_cscoms.com>
Date: Fri, 6 Apr 2001 10:17:39 +0700
Message-ID: <9ajcpo$t1j$1@news.loxinfo.co.th>

Try this:

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

--
+++
Beat Christen       chbeach_at_loxinfo.co.th
Phuket/Thailand
+++


"nyu" <nyu_at_genomicfx.com> wrote in message
news:3acd0cc9$0$63446$736b3e2_at_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 - 22:17:39 CDT