I am trying to export to a file with a specific name. How can I add the exact timestamp (in any format) at the time of generation of the export file, to the file name? The SQL for the export will be run from a script saved in the DB@ Scheduler. It is not a Stored Procedure.

Thanks a lot for any help.

in unix enviroment you can use

<file_name>.`date`

there are many options for the date you can use to your advantage.
regard.

mujeeb

thanks, mujeeb. i'll try that.