Categories
Unix Timestamp in OBIEE 11g

Hi,
I have unix timestamp column , that I want to convert normat date and timestamp. And I want to use that column as dashbord prompt.
In DDR it was working fine but user want to enter date value through prompt.
DATEADD(s, open_date, '1/1/1970 05:30:00 AM') AS [Open Date],
Thanks,
Ramesh
Answers
-
Define it as a logical column in the BMM.
https://lmgtfy.com/?q=obiee+unix+epoch
First hit: https://thinkbi.wordpress.com/2009/01/09/converting-unix-epcoh-time-in-to-date-using-obiee/
0 -
Hi,
I have tried but I am getting below error
Function TimestampAdd is called with an incompatible type
TimeStampAdd(SQL_TSI_SECOND, "ServiceDesk"."A_Call_req"."open_date" , '1/1/1970 05:30:00 AM')
Thanks,
Ramesh
0 -
Did you read the link posted by @rmoff ?
Did you "debug" a bit your error? For example replace one of the 2 arguments with a different value to find out which one give you the error?
But I guess it's the date...
Because you write '1/1/1970 05:30:00 AM' assuming it's a date while that is just a varchar ...
The link show a different syntax and OBIEE also has few other ways to convert a string into a date.
0 -
Hi
Thanks,
Final Query
TimeStampAdd(SQL_TSI_SECOND, "ServiceDesk"."A_Call_req"."open_date" , TIMESTAMP '1970-01-01 00:00:00.000')
0