Change the timestamp format during "Export Tables"

[cn20082008]

I have a table with a timestamp column that I am exporting using the "Tools -> Export Tables" option.

Is there a way to control the format of the timestamp while exporting.

Eg:
-- Insert statement generated by default
insert into TEMP_TABLE(EFF_DT)
values (
to_timestamp('01-01-2004 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff')
);

I would like the format to be:
YYYY-MM-DD HH24:MI:SS

I tried altering the NLS_TIMESTAMP_FORMAT. But that only works for the SQL window, not during export.
(Also, changing the Tools->Date/Time preference has no effect even in the SQL window)

Any help would be appreciated..

Thanks

 

[Marco Kalter]

No, this cannot be controlled.