OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » import date with apex utility (apex 2.1 oracle 10g xe)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import date with apex utility [message #523857]

Tue, 20 September 2011 13:52

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

Report message to a moderator

Re: import date with apex utility [message #524446 is a reply to message #523857]

Fri, 23 September 2011 14:12

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>

Report message to a moderator

Previous Topic:	Login Page
Next Topic:	Reporting tool for APEX

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 06 10:47:38 CDT 2023