TimeStamp to Time or Date

CRX

I have columns in the following format:

"10/10/2016 8:14:24"

How can I reduce this to "10/10/2016" or "8:14:24"

Within OBIEE 12C;

Sherry George

Assuming this is for an analysis, you can change the format in the column properties.

Example:

Thomas Dodds

BEST:  do it in ETL and store two keyed columns to join to DATE and TIME dimensions

BETTER:  do it in the physical column mapping of a logical column in RPD

CRX

I'll do a test and come back with an okay