Skip to Content
0
May 06, 2010 at 03:37 AM

convert character datatype to date datatype for date field

118 Views

Hi all,

i am connecting to sql server 2005 through universe designer.

the dates in sql database are in the following format

'YYYYMMDD' -> datatype is character.

Now In the universe i would like to convert datatype 'character' to 'date' .

How to achieve this?