Skip to main content

developerWorks >  Information Management  >  Forums  >  Cognos Series 7  >  developerWorks

Interpreting Unix timestamp    Point your RSS reader here for a feed of the latest messages in this thread


     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
This question is not answered.

Permlink Replies: 0 - Pages: 1 Threads: [ Previous | Next ]
alanD

Posts: 7
Registered: Dec 13, 2005 06:48:24 AM
Interpreting Unix timestamp
Posted: Nov 05, 2009 06:06:15 AM
 
Click to report abuse...   Click to reply to this thread Reply
I am using Impromptu to query an Oracle data table that uses numeric fields to hold date/time information.

The fields contain a Unix timestamp - milliseconds since 1/1/70.

Is there any way of using Impromptu functions to convert these into meaningful dates?

As an example, 1257325343000 converts to 4-Nov-2009 09:02:23
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums