Home » Developer & Programmer » Data Integration » OWB operator to convert VARCHAR2 data type into a DATE data type in target table
OWB operator to convert VARCHAR2 data type into a DATE data type in target table [message #432283] Mon, 23 November 2009 07:06 Go to next message
shabir46
Messages: 40
Registered: November 2009
Member
Hi ,

Please can you tell me whether is there any built in operator in OWB which can convert a VARCHAR2 data type into a DATE data type in the target table?


Thanks ,
Shabir Kaithayil
Re: OWB operator to convert VARCHAR2 data type into a DATE data type in target table [message #432414 is a reply to message #432283] Tue, 24 November 2009 01:12 Go to previous message
Littlefoot
Messages: 21102
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
TO_DATE function is capable of doing that (if you specify a correct format).
Previous Topic: XML as source in OWB
Next Topic: Simple Tutorials for Newbie
Goto Forum:
  


Current Time: Sat May 27 07:08:36 CDT 2017

Total time taken to generate the page: 0.07163 seconds