Problem in executing sed command

Hi,

Input: XX = to_date ('9999-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS')

Required output: XX=to_date (\'9999-12-31 23:59:59\', \'YYYY-MM-DD HH24:MI:SS\')

Regards
Akshu

XX= echo $XX|sed 's/*situation now*/*what you want*/'

would probably work

sed "s/ = /=/;s/'/\\\'/g" infile
# cat tst
XX = to_date ('9999-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS')
# sed "s/ = /=/;s/'/\\\'/g" tst
XX=to_date (\'9999-12-31 23:59:59\', \'YYYY-MM-DD HH24:MI:SS\')

Thanks It works fine!!