SAP Knowledge Base Article - Preview

2360826 - Feature request for IQ to LOAD epoch time into the desired timezone timestamp - SAP IQ 16

Symptom

Feature request for IQ to load epoch time into the desired timezone timestamp.

 

Definition of Epoch Time (from Wikipedia):

Unix time (also known as POSIX time or Epoch time) is a system for describing instants in time, defined as the number of seconds
that have elapsed since 00:00:00 Coordinated Universal Time (UTC), Thursday, 1 January 1970, not counting leap seconds.

For example:

The feature request is to load the epoch time into a timstamp in IQ with the possibility to choose the time zone.

The desired behavior is to read the epoch time and automatically convert it to IST, if IST is chosen.

Epoch Time

UTC

IST (time in India)

1469190655

2016-07-22 12:30:55.000

2016-07-22 18:00:55.000


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

feature request ; feature ; request ; CR 801429 ;  801429 ; epoch time ; load table ; UTC ; time zone ; convert ; , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.