Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need to calculate week ending.
maybe something along this line
select sysdate - to_char( sysdate, 'd' ) + 7 from dual;
"Craig Lehn" <clehn_at_consystint.com> wrote in message
news:3c74e6fc$1_8_at_goliath.newsgroups.com...
> How do you calculate weekending using an insert into "table" select blah
> query? Currently afterwards I use a cursor and an update query after the
> fact to insert all the data into the table. this takes however a minute or
> so. Any way to calculate weekending on the insert?
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Thu Feb 21 2002 - 12:43:07 CST