Why does Hyperion's Trunc(date) return large number?

Question

I am working with Hyperion and I have never used it before about two weeks ago. Someone else set up a .bqy file to get certain columns from a DB. He has one column with this formula in it: Trunc(date) where date included the date and time.

What that column shows, though, is not the date. It shows large numbers like this: 1,377,826,863,000. They all end in 000.

What are those numbers?

score 0 · Accepted Answer · edited May 23 '17 at 12:13

0

Probably milli-seconds since the Epoch of 1/1/1970 with a resolution of 1 second, hence the 3 zeroes at the end. See Wikipedia article for "Unix Time" here.

You can convert to a string, using one of the methods here.

edited May 23 '17 at 12:13

Community

1
1

answered Dec 06 '13 at 23:36

Mark Setchell

191,897
31
273
432

I think you may be right! Do you know how to convert a date to Unix Time with an equation? I need to convert it to a Crystal Report. – HighHopes Dec 06 '13 at 23:51
By the way, you can use the command "date +%s" to get the current Unix time, which stands at 1387788995 as I write this. – Mark Setchell Dec 23 '13 at 08:59

Why does Hyperion's Trunc(date) return large number?

1 Answers1