Concatenate a Date

User_IA53R

Hi, im trying to concatenate a date (date of birth) with first name and last name but running into a error.. these are the columns,, TIA this is what I have so far.

"Enterprise - Account"."Customer"."First Name" ||' '|| "Enterprise - Account"."Customer"."Last Name" ||' '|| "Enterprise - Account"."Customer"."Date Of Birth"

Just the columns below so no confusion

"Enterprise - Account"."Customer"."First Name"

 "Enterprise - Account"."Customer"."Last Name"

"Enterprise - Account"."Customer"."Date Of Birth"

[Deleted User]

Hello nameless forum user,

A couple of things:

a) https://community.oracle.com/tech/apps-infra/kb/articles/4-how-to-ask-questions-in-developer-community-spaces

Please try to write questions with a minimum of effort by supplying necessary and relevant information like a full and complete version number. Example: "OBIEE 12.2.1.4.200721" or "OAS 6.4.160322"

b) If you get an error message, then post the error message and/or a screenshot!

c) Three things are important when working with data: Data types, data types, and data types! You can't concatenate DATE data types - you need to transform them:

"Enterprise - Account"."Customer"."First Name" ||' '|| "Enterprise - Account"."Customer"."Last Name" ||' '|| cast("Enterprise - Account"."Customer"."Date Of Birth" as VARCHAR(50))