Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Concatenate a Date

Received Response
31
Views
1
Comments
User_IA53R
User_IA53R Rank 2 - Community Beginner
edited Aug 13, 2024 5:03PM in Oracle Analytics Cloud and Server

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"

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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))