Skip to Content

Type String to DateTime

Hi Experts,

I need to change the datatype in IDT(information design tool) my source is Oracle. From the Date Dimension object, i am getting the date formate as 20-SEP-2015 which is of type string i need to convert to same date format with only datetype change as datetime@the Universe Level


I would need Date Dimension object as datetime type rather String type


Using Oracle 11g and IDT 4.1


Thanks,

Dinya.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 14, 2015 at 06:15 PM

    Hi,

    Use todate function to convert in the date.

    toDate(@Select(Test\Date))


    Amit

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 18, 2015 at 02:16 PM

    Hi Amit,

    Below the issue. Date type set as date only...

    In Webi:

    Thanks,

    Dinya


    pastedImage_0.png (13.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      "use database specific SQL option" option is available only with multi source universe when you are connecting with multiple data sources.Otherwise you will find it's disabled.


      yes you can use one parameters in the to_date function. If you are not sure then when you will click on validate you will get the error.Universe designer is enough smart to tell you which syntax will work and which will not work 😊.


      Amit


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.