Home » Developer & Programmer » Warehouse Builder » 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: 20891
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 Dec 03 19:53:42 CST 2016

Total time taken to generate the page: 0.04011 seconds