Solve : Concat the SYSDate to a output filename?

1.	Solve : Concat the SYSDate to a output filename?
Answer» Could someone share with me how to Concatenate the SysDate to a Output file from a executing Bat file. Ex) Oracle_sqlfile.bat sqlplus login/password @abc.sql > xyz_sysdate.txt exit; I don't know how to MAKE the syntax work. thanks MCCYou didn't mention an OS, so this is just a guess: Code: [Select]@ECHO off set sysdate=%date:~10,4%%date:~4,2%%date:~7,2% sqlplus login/password @abc.sql > xyz_%sysdate%.txt exit Hey, it might even work. 8-) Oracle is in a Window 2000 environment. MCCThe code posted should work in a Win2000 environment. If not, lets us know; there are countless ways to extract and rearrange MONTH, day and YEAR from a date.

Discussion