Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Day of week function?

Re: Day of week function?

From: Vents Lauva <vents_lauva_at_mailserv.fix.lv>
Date: Wed, 03 Jun 1998 09:18:29 +0300
Message-ID: <3574EAB5.EAB0E486@mailserv.fix.lv>

Mark Aurit wrote:

> if day_of_week_is('Friday',sysdate) then
> ... perform friday processing
> else
> ... perform other days processing
> end if

Try:

if to_char(sysdate,'DAY') = 'FRIDAY' then .....

Vents Lauva
vents_lauva_at_fix.lv Received on Wed Jun 03 1998 - 01:18:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US