Export tables, date format customization

[Mindaugas]

I export table data as inserts, and date format is

to_date('25-04-2008 11:44:19', 'dd-mm-yyyy hh24:mi:ss')

I need different

to_date('3000.01.01', 'YYYY.MM.DD')

how can I change it?
The same goes for PROMPT text (I would like translate it)

Specify column value. Let's say, I have date column (or user). When exporting, instead of date value '3000.01.01' (or 'someUser') I would like to insert string SYSDATE (or USER). This will give me system time (or user name), when executing *.sql

Thank you!

------------------------
PL/SQL Developer
Version 7.1.5.1397
01.39295 - 5 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 2.071.792 kB (1.106.372 available)
Paging file : 3.450.488 kB (2.627.932 available)
Virtual memory : 2.097.024 kB (1.904.432 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\MindaugasL\default.ini

Plug-Ins
*SmartEd 2.0 Plug-In (C:\Program Files\PLSQL Developer\PlugIns\SmartEd.dll)
(* is Active)

Aliases
EXTPROC_CONNECTION_DATA
KVP
UMNWORK
WORK

Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)

DLLs
C:\oracle\product\10.2.0\client_1\bin\oci.dll

TNS File
C:\oracle\product\10.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0

Character Sets
Character size: 1 byte(s)
CharSetID: 179
NCharSetID: 2000
Unicode Support: True
NLS_LANG: LITHUANIAN_LITHUANIA.BLT8MSWIN1257
NLS_CHARACTERSET: BLT8MSWIN1257
NLS_NCHAR_CHARACTERSET: AL16UTF16

 

[Marco Kalter]

This is currently not possible. Why do you need a different date format? The to_date() function will convert it correctly.

 

[Mindaugas]

PL/SQL developer has some default to_date(). I couldn't find, how to customize it (specify my date format string 'YYYY.MM.DD')

How can I add different string format to_date(), which is then used in generated insert script?

 

[Marco Kalter]

I'm not sure what you mean. PL/SQL Developer will always explicitly specify the date format.