TimeStamp to Time or Date

Question

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;

CRX · Answer

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

Thomas Dodds · Answer

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

Sherry George · Answer

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

Example: