WbExport - filename with timestamp

[Darshak]

Hi,

I need to run SQLs daily using WbExport and generate output file's name with timestamp .

e.g. output_14dec2022.txt

Is it possible using WbExport on Windows ?

Thanks

Darshak

[Thomas Kellerer]

You can create a variable based on a SELECT statement:

(Postgres syntax)

WbVarDef today=@"select to_char(current_date, 'yyyy_mm_dd')";
WbExport -file=export_$[today] ....;


Regards
Thomas

Darshak schrieb am 14.12.2022 um 14:06:
> Hi,
>

> I need to run SQLs daily using WbExport and generate /output file's name /with timestamp .

[Darshak]

Thanks a lot, will try given solution.