OraFAQ Forum: Windows » spool file to file with the date as suffix

Home » Infrastructure » Windows » spool file to file with the date as suffix (oracle 10g, windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

spool file to file with the date as suffix [message #335267]

Mon, 21 July 2008 12:13

eagyeman
Messages: 6
Registered: May 2007

Junior Member

I am creating a batch script in windows (DOS). The script is to spool the results of a query to a file named (for example)test_07212008_14:10:56.

Where 07212008 is the date the script will run and 14:10:56 is the time in HR24:MI:SS format.

I am a unix guy and this DOS thing is killing me. Any ideas as to how I can do this in windows.

Report message to a moderator

Re: spool file to file with the date as suffix [message #335277 is a reply to message #335267]

Mon, 21 July 2008 12:30

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why if you post a Windows question did you post this in Unix forum and Windows one?
If you had a look at Windows forum, you'd find answer to this question already asked several times.

Regards
Michel

Report message to a moderator

Re: spool file to file with the date as suffix [message #335294 is a reply to message #335267]

Mon, 21 July 2008 14:03

eagyeman
Messages: 6
Registered: May 2007

Junior Member

Thanks for all your help I have found a way to do it

Report message to a moderator

Previous Topic:	oracle sqlplus error ora-24324 and ora-01041?
Next Topic:	problem with batch file while scheduling RMAN backup (2 threads merged by bb)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 20 07:01:10 CDT 2025