Home » RDBMS Server » Server Utilities » To change date format
To change date format [message #166682] Fri, 07 April 2006 09:12 Go to next message
jamalmd
Messages: 6
Registered: December 2005
Location: India
Junior Member

Dear All,

Please send some documents about SQL Loader. It will be very useful
Source: 01-04-2006.

Destination?

How can I load this source data(01-04-2006) to oracle as oracle data format is (01-Apr-2006)

With thanks,
Jamal Md

Report message to a moderator

Re: To change date format [message #166685 is a reply to message #166682] Fri, 07 April 2006 09:41 Go to previous message
d_indrani
Messages: 8
Registered: November 2005
Location: Bangalore, India
Junior Member
Hi,
you can use your date field like below in your control file.

LOAD DATA
APPEND
INTO TABLE DSCS_TD_IN_INTERFACE
FIELDS TERMINATED BY ','
(
date_field "TO_DATE(:date_field, 'DD-MM-YYYY')"
)

I wish this solves your problem.

Report message to a moderator

Previous Topic: ....Sql Loader.. Another Delima
Next Topic: Issues with SQL loader Control file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 20:27:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.