Converting Epoch time

Hi All,

I am new to BIRT and need your help.

I am using a Postgres JDBC driver to connect to postgre sql server and could see the tables. I want your help in converting the epoch time to a regular time format.

How can I convert epoch time while creating a query.

Please give me some link which explains about this conventions process.

Find more posts tagged with

Comments

mwilliams

Hi my_birt,

I'll have to check into doing it in the SQL, however, you could create a computed column that converts the epoch time into a date and just use that column instead of the other.

my_birt

Hello Michael,

Thanks for your prompt reply.

Can you tell me how do I generate an expression in computed columns in order to convert epoch time to regular time ? What function I need to use in order to achieve my purpose ?

Thanks,
Srinivas.

my_birt

Can someone help me with this please !!

Thanks in advance,
Srinivas.

mwilliams

Srinivas,

Sorry for the delay. If you put the following in as the expression for a date type computed column, you should get the correct date. Let me know if you have questions.

new Date(70,0,1,0,0,row["epoch"])

my_birt

That's awesome. That wokrs great

Thanks for all your help

Srinivas.

mwilliams

Srinivas,

No problem, glad to help!

Let us know whenever you have questions.