Cast to timestamp
Hello,
OBIEE 11.1.1 answers question.
To recover full date time accuracy from a number of date / time elements I have concatenated up date / time elements to give me a full char version of a timestamp, however when I try to convert it to a timestamp to perform a calculation on it I get a general error, even though when I convert a timestamp to a char I see an identical date / time string in the format dd/mm/yyyy hh:mi:ss i.e. 31/01/2011 15:32:26
I have also tried switching the char datestring around to yyyymmdd.
Does anyone know the secret, the code examples from the manuals just do not work for timestamp as they say they should, i.e. you cannot cast a date directly to stamp, but you can cast it via a char to timestamp....
A simple example of converting a literal to a timestamp (including hours / minutes / seconds) would be ideal here.
And yes, I know this would be best created in the repository not in analytics.
many thanks,
Robert.