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
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.