Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » import date with apex utility (apex 2.1 oracle 10g xe)
import date with apex utility [message #523857] Tue, 20 September 2011 13:52 Go to next message
hudo
Messages: 165
Registered: May 2004
Senior Member
I unloaded a table with the apex 2.1 utilitys --> unload, then I tried to load these data with the apex 2.1 utilitys --> Data load
The Problem seems to be the date format. In the exported I file the date is written like this 2009-10-23T13:13:23

What do I have to use as format mask to import the date ?
I tried already yyyy-mm-ddTHH24:MI:SS and yyyy-mm-dd HH24:MI:SS
Re: import date with apex utility [message #524446 is a reply to message #523857] Fri, 23 September 2011 14:12 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
SQL> select to_char(sysdate, 'yyyy-mm-dd"T"HH24:MI:SS') from dual;

TO_CHAR(SYSDATE,'YY
-------------------
2011-09-23T12:10:59

SQL>
Previous Topic: Login Page
Next Topic: Reporting tool for APEX
Goto Forum:
  


Current Time: Thu Mar 28 14:44:39 CDT 2024