Converting miliseconds to seconds timestamp

system · February 5, 2013, 12:57pm

Hi all,
I am trying to create the Start/End Timestamp in Universe but the Database that i have has the START_TIME or END_TIME in miliseconds timestamp.
For example 1360068876434 is Tue, 5 Feb 2013 12:54:36 UTC.
As a result of the above universe cannot recognise this as a date object type.
Is there any solution to this?

silver1982 (BOB member since 2012-07-17)

system · February 5, 2013, 2:46pm

HI,

What database do you use?

Marek Chladny (BOB member since 2003-11-27)

system · February 6, 2013, 8:21am

The database is Oracle

silver1982 (BOB member since 2012-07-17)

system · February 6, 2013, 8:37am

At the moment I convert using to_char and then back again with to_date, but if there’s a better way, I’d love to hear it too!

debbie

Debbie (BOB member since 2005-03-01)