Re: last_day/time

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 2000/05/12
Message-ID: <391c5f0a.2294178@172.16.7.5>#1/1

On Thu, 11 May 2000 17:11:25 -0400, "Nick G. Anagnos" <anagnon_at_westat.com> wrote:

Hello,

Try this !

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') now from dual;

NOW

---

2000-05-12 09:32:28

SQL> SQL> select to_char(trunc(add_months(sysdate,1),'mm') -

                         (1/(24*60)),'yyyy-mm-dd hh24:mi:ss') "min"
        2  from dual
        3  /

min

---

2000-05-31 23:59:00

SQL> Violin.
violin.hsiao_at_mail.pouchen.com.tw

>need a statement that will assign a variable the last day and
>time(23:59) based on the month the sql statement was run.
>
>ex. If the sql statement is run in May, 2000, assign 05/31/2000 23:59
>to a variable
>
>
Received on Fri May 12 2000 - 00:00:00 CDT