Home » RDBMS Server » Server Utilities » How to define date format such as 2002-6-14 12:30:44?
How to define date format such as 2002-6-14 12:30:44? [message #70438] Thu, 13 June 2002 20:00 Go to next message
flower
Messages: 2
Registered: June 2002
Junior Member
when I load a data file into Oracle,how to define date format such as 2002-6-14 12:30:44?

Report message to a moderator

Re: How to define date format such as 2002-6-14 12:30:44? [message #70439 is a reply to message #70438] Thu, 13 June 2002 20:53 Go to previous message
Sujit Mahapatra
Messages: 19
Registered: March 2002
Junior Member
In the loader, mention the time part:

....
date_field date "yyyy-mm-dd hh24:mi:ss"
....

Hope that should work. But I doubt your month
field is not in MM format. Just check this out.

Revert back when problem:

Cheers
Sujit

Report message to a moderator

Previous Topic: Delimited file load - URGENT
Next Topic: Listener Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 11:19:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.