Timestamp - Revision history

Maxim@tygron.com at 07:27, 9 July 2026

2026-07-09T07:27:29Z

← Older revision		Revision as of 07:27, 9 July 2026
Line 49:		Line 49:
	Here the letters indicate the way the numbers are automatically interpreted by the Date parser used in the {{software}}. Before importing CSV data, ensure the project's timestamp format matches the format used in your file.		Here the letters indicate the way the numbers are automatically interpreted by the Date parser used in the {{software}}. Before importing CSV data, ensure the project's timestamp format matches the format used in your file.

	~~When you don't configure it correctly, you might receive errors of~~ unrecognized timestamp ~~formats,~~ or ~~worse, import the dates wrongly~~ without ~~any notice~~.		Incorrect configuration may result in unrecognized timestamp format errors or incorrect date imports without notification.

	{{gallery		{{gallery

Frank@tygron.nl at 14:03, 8 July 2026

2026-07-08T14:03:55Z

← Older revision		Revision as of 14:03, 8 July 2026
Line 5:		Line 5:

	==Timestamp format==		==Timestamp format==
	~~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].		The required symbols are described below. More details can be found at [https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html#patterns java's DateTimeFormatter patterns].

	===Symbols===		===Symbols===
Line 47:		Line 47:
	* yyyy/MM/dd hh:mm:ss		* yyyy/MM/dd hh:mm:ss
	* MM dd yyyy hh		* MM dd yyyy hh
	Here the letters indicate the way the numbers are automatically interpreted by the Date parser used in the {{software}}. ~~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.		Here the letters indicate the way the numbers are automatically interpreted by the Date parser used in the {{software}}. Before importing CSV data, ensure the project's timestamp format matches the format used in your file.

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

Frank@tygron.nl: /* Symbols */

2025-09-10T07:53:34Z

Symbols

← Older revision		Revision as of 07:53, 10 September 2025
Line 8:		Line 8:

	===Symbols===		===Symbols===
			The most occurring symbols are listed in the table below. Note that the capitalization of the symbol is important.
	{\| {{STDT}}		{\| {{STDT}}
	! Symbol		! Symbol
Line 37:		Line 38:
	\| 55,12, 6		\| 55,12, 6
	\|}		\|}

	For the full timestamp format table , see [[Timestamp pattern table]].		For the full timestamp format table , see [[Timestamp pattern table]].

Frank@tygron.nl at 07:40, 10 September 2025

2025-09-10T07:40:10Z

← Older revision		Revision as of 07:40, 10 September 2025
Line 61:		Line 61:
	* seconds are with a small s. A large '''S''' is a fraction of second (milliseconds)!		* 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!		* day of month is with a small d. A large '''D''' is a day of year!
	* year should be denoted with a small y. A large Y is week-based-year, which may deviate subtly		* year should be denoted with a small '''y'''. A large Y is week-based-year, which may deviate subtly
	\|videos=		\|videos=
	{{video\|gallery=		{{video\|gallery=

Frank@tygron.nl: /* Symbols */

2025-09-10T07:29:12Z

Symbols

Show changes

Frank@tygron.nl: /* Symbols */

2025-09-10T07:27:27Z

Symbols

← Older revision		Revision as of 07:27, 10 September 2025
Line 205:		Line 205:
	\|		\|
	\|-		\|-
	\| ''		\| ' '
	\|single quote		\|single quote
	\|literal		\|literal

Frank@tygron.nl: /* Symbols */

2025-09-10T07:27:10Z

Symbols

← Older revision		Revision as of 07:27, 10 September 2025
Line 205:		Line 205:
	\|		\|
	\|-		\|-
	\|''		\| ''
	\|single quote		\|single quote
	\|literal		\|literal
	\|		\| '
	\|'
	\|-		\|-
	\|[		\|[

Frank@tygron.nl: /* Symbols */

2025-09-10T07:26:37Z

Symbols

← Older revision		Revision as of 07:26, 10 September 2025
Line 203:		Line 203:
	\|escape for text		\|escape for text
	\|delimiter		\|delimiter
			\|
	\|-		\|-
	\|''		\|''
	\|single quote		\|single quote
	\|literal		\|literal
			\|
	\|'		\|'
	\|-		\|-
	\|[		\|[
	\|optional section start		\|optional section start
			\|
			\|
	\|-		\|-
	\|]		\|]
	\|optional section end		\|optional section end
			\|
			\|
	\|-		\|-
	\|#		\|#
	\|reserved for future use		\|reserved for future use
			\|
			\|
	\|-		\|-
	\| {		\| {
	\|reserved for future use		\|reserved for future use
			\|
			\|
	\|-		\|-
	\| }		\| }
	\|reserved for future use		\|reserved for future use
			\|
			\|
	\|-		\|-
	\|}		\|}

Frank@tygron.nl: /* Symbols */

2025-09-10T07:26:00Z

Symbols

← Older revision		Revision as of 07:26, 10 September 2025
Line 188:		Line 188:
	\|zone-offset		\|zone-offset
	\|offset-x		\|offset-x
	\|+0000; -08; -0830; -08:30; -083015; -08:30:15;		\| +0000; -08; -0830; -08:30; -083015; -08:30:15;
	\|-		\|-
	\|Z		\|Z
	\|zone-offset		\|zone-offset
	\|offset-Z		\|offset-Z
	\|+0000; -0800; -08:00;		\| +0000; -0800; -08:00;
	\|-		\|-
	\|p		\|p

Frank@tygron.nl at 07:25, 10 September 2025

2025-09-10T07:25:14Z

← Older revision		Revision as of 07:25, 10 September 2025
Line 224:		Line 224:
	\|reserved for future use		\|reserved for future use
	\|-		\|-
			\|}

	===Example formats===		===Example formats===