Shell Programming and Scripting

datenow=`date '+%d-%h-%Y'`

sqlplus $dbuserid/$dbpassword @ $SCRIPT_PATH/business-date.sql > $SCRIPT_PATH/business-date.tmp

dbdate=`grep 'BusinessDate' $SCRIPT_PATH/business-date.tmp |cut -c1-11`

# value of business-date.tmp >>>  dd-Mmm-yyyy BusinessDate
# value of dbdate is in format  dd-Mmm-yyyy

if [ $dbdate -ge $datenow ]   
then
   echo "date rolled-over"
   SendOKmail
else
   SendNOTOKEmail
fi

#!/usr/bin/env ksh

# dates1 and 2 on command line (dd-MMM-yyyy) are converted to yyyymmdd
# and numerically compared.  A single digit is written to stdout to indicate the relationship:
#    -1  when d1 < d2
#    0   when equal
#     1  when d1 > d2 
#
function cmp_dt
{
    awk -v d1=$1  -v d2=$2 '
    BEGIN { soup = "JanFebMarAprMayJunJulAugSepOctNovDec";
        split( d1, sd1, "-" );
        split( d2, sd2, "-" );
        m1 = int(index( soup, sd1[2] ) / 3) + 1;
        m2 = int(index( soup, sd2[2] ) / 3) + 1;
        id1 = sprintf( "%4d%02d%02d", sd1[3], m1, sd1[1] )+0;
        id2 = sprintf( "%4d%02d%02d", sd2[3], m1, sd2[1] )+0;
        print (id1 > id2 ? 1 : 0  id1 < id2 ? -1 : 0);
    }'
}


# assign datenow and dbdate

if (( $(cmp_dt $dbdate $datenow) >= 0 ))
then
    echo "date rolled over"
else
    echo "date is ok"
fi

#! /bin/bash

date1="02-Dec-2011"
date2="02-Oct-2011"

d1m=`echo $date1 | cut -d- -f2`
d2m=`echo $date2 | cut -d- -f2`

i=1
for m in Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
do
    [ "$d1m" == "$m" ] && d1m=$i
    [ "$d2m" == "$m" ] && d2m=$i
    i=$(($i + 1))
done

date1=$(echo $date1 | cut -d- -f3)$(printf "%02d" $d1m)$(echo $date1 | cut -d- -f1)
echo "date1 = $date1"
date2=$(echo $date2 | cut -d- -f3)$(printf "%02d" $d2m)$(echo $date2 | cut -d- -f1)
echo "date2 = $date2"

[ $date1 -gt $date2 ] && echo "date1 gt date2"