caseexpression [message #277345] |
Mon, 29 October 2007 12:28  |
dr46014
Messages: 49 Registered: February 2007
|
Member |
|
|
hi
can anyone please help me writing a sql case expression where a date parameter data_date is passed.if the day of the date is sunday or monday then file_date becomes data_date-2 and for rest other days its data_date-1.
|
|
|
|
Re: caseexpression [message #277452 is a reply to message #277345] |
Tue, 30 October 2007 03:21  |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Try something like this:select case when to_char(data_date,'DY') in ('SUN','MON') then data_date-2
else data_date -1 end
from dual;
|
|
|