Support different TimesStamp formats when Modifying Views
Currently it is not possible to change the TimeStamp format from MM/dd/yyyy 12h AM/PM to other formats. Since there are many potential different data endpoints, it may be a good idea to allow users to change to other formats, such as 24h Military time.
Please see the following article for the available built-in timestamp formats including ISO: Can I change the timestamp format in the PI Integrator for BA? (https://customers.osisoft.com/s/knowledgearticle?knowledgeArticleUrl=Can-I-change-the-timestamp-format-in-the-PI-Integrator-for-BA).
Bala Satuluri commented
We are trying to write data to S3 buckets using the built-in connector but need the data in dd/mm/yyyyThh:mm:ss but the specific format is not available even after changing to string and going through different options that are available. It would be great if we have the capability to create custom columns (more like PowerQuery) and if not, date formatting options atleast.
Just to clarify, this enhancement request is for the user to be able to create their own custom timestamp format. If you are looking for more timestamp options but not looking to create your own, you can select a different time format from the available options in the Integrator (see section Add a Time Column at https://livelibrary.osisoft.com/LiveLibrary/content/en/bi-v5/GUID-BF7530CE-3706-4620-BD92-8F7715E1210C )(Edited by admin)
A timestamp option that includes subseconds would also be good especially for streaming data (e.g. YYYY-MM-DD hh:mm:ss.hhh)