Need help with shellscript

Hello. I am a novince at writing shell scripts but here is the question. I have to write a shell script that does the following:

Once executed via crontab, the script should do the following:
a. get date/time stamp in for format 10-MAR-05 and
b. execute shell script my_script.sh (which collects information
c. pass date/timestamp to sqlquery
d. email output of this to recipies using mailx.

Can you give me an example on how to do this?

thanks
Jigar

Can u elaborate the question?

Can you show us what you have for your script and sql ?

Otherwise ...
a. man date
b. man crontab
c. need to see your sqlquery
d. man mailx

Cheers,
Cameron