Changing a String Dimension to Date

[Former Member]

Hi,

I have a column in the database set as string for date (1/11/2011). I have to use this as date in my universe. How can I do this type conversion while defining the universe dimension.

[swati_patil4]

Hi Vaibhav,

In Universe you can convert String to Date and used this as a Date object.

E.g. In case of Oracle database Todate() is the function we can use for converting String to Date format.

Todate('30/11/2012' ,'DD/MM/YYYY')  will give you date in form of 30/11/2012.

This fuction you can use at Universe level giving your String field.

Please let me know if it helps.

Thanks,

Swati