How to extract date and time from timestamp in designer?

building semantic layer
1

hi,
My database is oracle.I have a field like date_time as timestamp datatype.
example:09/01/2006 00.00.02

In my report i need to create two seperate columns as date and time.and populate the data into this 2 columns .My doubt is can i create 2 seperate objects in universe and can extract the date and time from timestamp with regarding to my db connection pointing to oracle at the universe level.

plz can anybody help me out the exact approach for this…

Thanks in advance :? :idea:

sahana (BOB member since 2007-11-15)

2

First col ToDate(Date_field, ‘dd-MM-yy’)
col2
ToDate(Date_field, ‘HH:MI:SS’)

See http://www.psoug.org/reference/date_func.html

Mick

mikca :australia: (BOB member since 2005-12-16)

3

Thanks… a lot…

Have got the clue…

:stuck_out_tongue: :slight_smile:

sahana (BOB member since 2007-11-15)