Timestamp: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 2: Line 2:




The Timestamp format used in your project can be changed in in the Project Detail panel. This format will be used to interpret timestamps present in time-values CSV data, used for example by an [[Inlet Q]]'s dynamic range in the Water Overlay Wizard.
The Timestamp format used in your project can be changed in in the Project Detail panel. This format will be used to interpret timestamps present in time-values CSV data, used for example by an [[Inlet Q (Water Overlay)|Inlet Q]]'s dynamic range in the Water Overlay Wizard.


This format does require a certain symbology. In short we will describe it here. More details can be found at [https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html#patterns java's DateTimeFormatter patterns].
This format does require a certain symbology. In short we will describe it here. More details can be found at [https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html#patterns java's DateTimeFormatter patterns].

Revision as of 14:41, 21 July 2020

This page is currently under construction...


The Timestamp format used in your project can be changed in in the Project Detail panel. This format will be used to interpret timestamps present in time-values CSV data, used for example by an Inlet Q's dynamic range in the Water Overlay Wizard.

This format does require a certain symbology. In short we will describe it here. More details can be found at java's DateTimeFormatter patterns.

Symbol Meaning Examples
y year 2004; 04
M month of year 7; 07; Jul; July; J
d day of month 10; 31; 4;
H hour of day (0-23) 0; 4; 13; 23
m minute of hour 0, 31, 47, 60
s second of minute 55,12, 6

Example of Timestamp Formats are:

  • yyyy-MM-dd
  • MM-dd-hh-mm
  • dd/MM/yy hh:mm:ss
  • yyyy/MM/dd hh:mm:ss
  • MM dd yyyy hh

Here the letters indicate the way the numbers are automatically interpreted by the Date parser used in the Tygron Platform. It is important that when you start importing CSV data with timestamps, you should first check what Timestamp formats are in the file and adjust the project's timestamp format to that format.

When you don't configure it correctly, you might receive errors of unrecognized timestamp formats, or worse, import the dates wrongly without any notice.

Note

Important:

  • minutes are with a small m and Months are with a capital M!
  • seconds are with a small s. A large S is a fraction of second (milliseconds)!
  • day of month is with a small d. A large D is a day of year!