Claculated column for TimeStamp

[Former Member]

Hi Experts,

   I'm trying to create Analytical view on a table.My table data is

My scenario is to convert data(Seconds) in "ZSTP" column into Time Stamp format. And date is starting from '1990-01-01 00:00:00' I want to create Calculated column(Attribute) with data type TIMESTAMP. I gave expression

But It's not working. Can any one help me.'TSTP' column data type is double. My result should be in TIMESTAMP Format.

I've tried in Oracle. i got result as shown below.

Thanks,

Vishali Raghava Raju

[Former Member · Accepted solution]

Hi Experts,

  I got the solution. So that I'm closing this "thread".

Thanks,

Vishali Raghava Raju

[Former Member]

Hi Experts,

  I attached below files for screen shots

Expression is

"TO_TIMESTAMP('1990-01-01','YYYY.MM.DD') + longdate(double(rtrim(string("ZTSP"),'0')) / 24 / 60 /60)"

Thanks,

Vishali Raghava Raju