How to Convert EPOCH (Unix Time) to Standard Time

[cognos.monster]

Hi,

my source generates EPOCH time, how do i convert it to a more human readable format?  I want to do this in framework manager so i could extract the day, month, hour, minutes, secs, out of it .

has anyone done this?

Thanks!

[the6campbells]

assuming you meant the UNIX epoch

your RDBMS may provide a function specifically to do this

from an ISO-SQL perspective as supported in a query/data item you could define this expression which returns a timestamp with timezone adjusted by the interval number of seconds represented by the epoch. Then you can format it as that type and so on.

1970-01-01 00:00:00.000000000+00:00 + cast(  <numeric-value>  , interval second)

[tjohnson3050]

You could try using a date dimension that accounts for unix time:

Here is link to a script that will create a date dimension with a field for the beginning and ending Unix Time for every day in the date dimension.  You can join to your unix time field in the source by doing >= unix begin time and <= unix end time, then do all kinds of date reporting.  The script is for SQL Server, so if you have a different data source, you can use it, but you could reverse engineer the logic for it.

http://www.cognoise.com/community/index.php?topic=18304.0