Pages

Tuesday 15 March 2011

Char to Date

How to convert a CHAR to a Date datatype.

Assuming that the format of the char date is consistent the easiest is to use the EVALUATE function

EVALUATE('TO_DATE(%1,%2)' AS DATE,,'dd/mm/yyyy')

Here's a good article on more with changing a CHAR using the CAST function in OBIEE.

Happy Hacking
Posted by at
Labels: , , ,

3 comments:

  1. Anonymous20 November 2017 at 01:05

    Good way of telling, andd nice article to take data regarding my presentation focus, which i am going to deliver in university.

    ReplyDelete
  2. Anonymous18 April 2018 at 09:53

    Good information. Lucky me I discovered your blog by accident (stumbleupon).
    I've saved it for later!

    ReplyDelete
  3. Anonymous18 April 2018 at 14:10

    I really like it when people get together and share views.

    Great blog, stick with it!

    ReplyDelete

Subscribe to: Post Comments (Atom)