GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Data Type conversion from VARCHAR2 to TIMESTAMP with time zone on column

edited Jun 20, 2012 5:47AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
I have a source database that has a table with column start_time defined as VARCHAR2.  My destination database has the table column start_time defined as TIMESTAMP with time zone.

I have created the following function. (not sure if it is needed). Can and how do I setup streams to do this type of conversion during the apply process?

Function change_date(date_in VARCHAR2)

begin

   return to_timestamp_tz(date_in, 'fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM TZH:TZM');

end;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center