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: 41
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: 21806
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: Thu Mar 28 13:36:47 CDT 2024