Unix Timestamp in OBIEE 11g

Question

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

961614 · Answer

Hi

Thanks,

Final Query

TimeStampAdd(SQL_TSI_SECOND, "ServiceDesk"."A_Call_req"."open_date" , TIMESTAMP '1970-01-01 00:00:00.000')

Gianni Ceresa · Answer

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.

961614 · Answer

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