Re: Last day/time
From: Kari Pannila <Xkari.pannila_at_tietoenator.com>
Date: 2000/05/12
Message-ID: <391BECB0.72ACBECD_at_tietoenator.com>#1/1
Date: 2000/05/12
Message-ID: <391BECB0.72ACBECD_at_tietoenator.com>#1/1
select to_char(last_day(sysdate),'DD/MM/YYYY')||' 23:59'
into your_variable
from dual;
--
Kari
(Mr.) Kari Pannila
Oracle DBA
--
PS. Delete X from my mail address , it (X) is only for SPAMMERS.
Poista X mail-osoitteen edestä, se on SPAMmereita varten.
"Nick G. Anagnos" wrote:
> 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 CEST