Date field column loading into Oracle Database?
Posted: Sat Jan 18, 2014 9:31 am
Hi All,
I have input is
Date,Time_Posted
------------------
8th November2013,12.30 midnight
21th July2013,8.30pm
13th December2013,8.00pm
9th May2013,12.30 midnight
11th April2013,12.30 midnight.
I want output as
-----------------------
Date,Time_Posted
8-11-2013,12.30 midnight
21-07-2013,8.30pm
13-12-2013,8.00pm
09-05-2013,12.30 midnight
11-04-2013,12.30 midnight
I want to load data into oracle database.
I would appreciate, if somebody can advise.
I have input is
Date,Time_Posted
------------------
8th November2013,12.30 midnight
21th July2013,8.30pm
13th December2013,8.00pm
9th May2013,12.30 midnight
11th April2013,12.30 midnight.
I want output as
-----------------------
Date,Time_Posted
8-11-2013,12.30 midnight
21-07-2013,8.30pm
13-12-2013,8.00pm
09-05-2013,12.30 midnight
11-04-2013,12.30 midnight
I want to load data into oracle database.
I would appreciate, if somebody can advise.