Need help to extract the date from the object

building semantic layer
1

Hello all,
I have one column in the table called ‘Time’.I want to make an object in the Universe for Date.I need to extract Date from this “Time” field.

The Data Type of “Time” is Date/Time in the DataBase.We are Using MySQL.

Can you Please Help me Out to make this Object.

Thanks in Advance.

Pooja :frowning: :frowning:

ktm :us: (BOB member since 2008-11-12)

2

Try using Cast() Pooja, a friendly note. I would suggest you to use the resources available and try to find out the first step towards the solution. I believe it will be of greater use for a long run.

Jansi :india: (BOB member since 2008-05-12)

3

Pooja,
I don’t have MySql to validate but how about trying this
DATE_FORMAT(TimeColumn,’%d/%m/%Y’)
Well you can use CAST function to covert the Data type explicitly
CAST(TimeColumn As Date)

Thanks
-Satish

forgotUN (BOB member since 2006-12-13)