Skip to Content
avatar image
Former Member

Error while converting yyyyMMdd to date in universe

Hello

We recently migrated from BO 3.1 to 4.1. While converting a character format of date from yyyyMMdd to date in unuverse we used to use the following  convert(date,@Select(Table\Date)). Bud it it is showing the following error.

To avoid this incompatibility, your data of the type 'Char' must be presented according to the Date format ''mm/dd/yyyy HH:m:s'', for example, '02/01/2014 11:50:59'.

Is there any solution??

Thanks

Anil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 01, 2014 at 04:38 PM

    Hi Anil,

    what is the backend Database you are using?

    Regards,

    Javed

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You cannot convert directly from int to date - you need to covert to char first.

      Use this:

      convert(date,cast(tablename.colname as CHAR(8)) ,112)

  • Apr 19, 2014 at 06:58 PM

    HI

    In IDT you can use create custom display format option in business layer....or use the function TO_CHAR

    Please find the below link.

    BI4.1 Business Layer Enhancements - Create Display Format

    Add comment
    10|10000 characters needed characters exceeded