Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    28

    Unanswered: export filename with timestamp

    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.

  2. #2
    Join Date
    Mar 2004
    Posts
    448
    in unix enviroment you can use

    <file_name>.`date`

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

    mujeeb

  3. #3
    Join Date
    Jun 2004
    Posts
    28
    thanks, mujeeb. i'll try that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •