Timestamp - Revision history

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

Frank@tygron.nl: /* Symbols */

2025-09-10T07:24:54Z

Symbols

Show changes

Rudolf@tygron.nl at 13:17, 9 September 2025

2025-09-09T13:17:02Z

← Older revision		Revision as of 13:17, 9 September 2025
Line 49:		Line 49:
	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.

			{{gallery
			\| mode=traditional
	~~<ul>~~		\| inlet_csv.png \| CSV for inlets with "dd/MM/yyyy HH:mm:ss" timestamp format
	~~<li style = "display:inline-block">[[File:~~inlet_csv.png\|~~250xpx]]<~~/~~li>~~		\| inlet_csv_xls.png \| XLSX view for inlets with "dd/MM/yyyy HH:mm:ss" timestamp format
	~~<li style = "display~~:~~inline-block~~"~~>[[File:~~inlet_csv_xls.png\|~~250xpx]]</li>~~		}}
	~~Example for a csv file~~ for inlets with ~~timestamps using the~~ dd/MM/yyyy HH:mm:ss ~~date~~ format		{{article end
	~~</ul>~~		\|notes=

	~~==Important Notes=~~=
	* minutes are with a small m and Months are with a capital '''M'''!		* 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)!		* 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
	=~~=See also=~~=		\|videos=
	~~[[File:YoutubeLogo1.jpg~~\|~~thumb~~\|~~left~~\|~~link~~=~~https://youtu.be/GnTkziMUyIU\|~~Import and export of large [[CSV]] datasets ~~containing timestamps (Dutch only)]]~~		{{video\|gallery=
			{{video\|youtube=GnTkziMUyIU\|language=dutch\|description=Import and export of large [[CSV]] timestamped datasets.}}
			}}
			}}