Skip to Content
Former Member
Mar 31, 2011 at 09:46 AM

convert varchar to date in BO Universe with Substring and instring function


to_date(substr(xxxx_v.e_details,instr(xxxx_v.e_details,'|',1,2)+1,9),'DD-MM-YYYY') In the universe while defining the object as date i was facing probs can any body help me out. the column xxxx_e_details is having the datatype varchar in database and the third string is date while i was creating the date object in the universe with the above syntax it was getting the error

The data in this obect is like this xxxx_v.e_details -> wwww|eeee|MM-DD-YY|

Edited by: mohammed kashif on Mar 31, 2011 11:47 AM