UNIX for Dummies Questions & Answers

Hi All,

I have a 2 questions; 1 is oracle and another is korn shell

say TIME=20060928
desired output: 20060927

say TIME=20061001
DESIRED output: 20060930

If i substract one day from 'TIME' i am looking for previous day.

can anyone please suggest me how do i do this is SQL.

i have another question; i am trying to write this is korn shell

KKK=a,b,c,d,e

if [ $KKK == 'a' or $KKK == 'c' or $kkk == 'e' ]; then
echo " i am here
else
echo " i am out"
fi

the above code that i wrote is not working.

can anyone please suggest me

thanks
mark

Code:

#!/bin/ksh

KKK='a,b,c,d,e'

if [[ "${KKK}" = @(*a*|*b*) ]] ; then
   echo "[$KKK] IS [a,b]"
else
   echo "[$KKK] NOT [a,b]"
fi;

Thanks a bunch

can anyone also please suggest me for the following

this is oracle question

say TIME=20060928
desired output: 20060927

say TIME=20061001
DESIRED output: 20060930

If i substract one day from 'TIME' i am looking for previous day.

can anyone please suggest me how do i do this is SQL.

thanks
mark

Hi All,

thanks to all of you for your suggestions;
this is how I tried

SQL> select to_date('20060928', 'YYYYMMDD') - 1 from dual;

TO_DATE('
---------
27-SEP-06

my desired output in this case is 20060927 but here the output is
coming as 27-SEP-06.

can anyone please suggest me how do I get the output as 20060927


thanks a bunch
mark

Code:

select to_char(to_date('20060928', 'YYYYMMDD') - 1 ,'YYYYMMDD')  from dual;