Date and Time Logic

Author: J. Spitzmüller © 2025
Menu: Table | Date and Time

Description

Date and Time Logic

Parameters

	Name	Type	Identifier	Description	Constraints
Input	Table	table, input	`TABLE`	-	-
Output	Output	table, output, optional	`OUTPUT`	-	-
Options	Timepoint Field	table field	`FIELD_TIMEPOINT`	-	-
	TimepointFormat	choice	`FORMAT_TIMEPOINT`	-	Available Choices: [0] Set Date [1] Set Date and Time [2] SAGA Date Field Type [3] Julian Day Number (JDN) [4] Modified Julian Day Number (MJD) [5] Unix Timestamp Default: 0
	Timepoint Date	date [GUI]	`DATE_TIMEPOINT`	-	Default: 2026-02-24
	Timepoint Time	text [GUI]	`TIME_TIMEPOINT`	-	Default: 17:40:20
	Timepoint ISO Time	text	`ISOTIME_TIMEPOINT`	-	Default: 2026-02-23T17:40:20
	Logical Operation	choice	`OPERATION`	-	Available Choices: [0] Is Earlier Than [1] Is Equal To [2] Is Later Than [3] Is Same Date [4] Is Same Time [5] Is Between [6] Is Strictly Between [7] Is Leap Year [8] Is Daylight Saving Time Default: 0
	Output	choice	`BOOL_AS`	-	Available Choices: [0] Bool [1] String Default: 0
	True String	text	`TRUE_STRING`	-	Default: true
	False String	text	`FALSE_STRING`	-	Default: false
	Other Field	table field	`FIELD_OTHER`	-	-
	OtherFormat	choice	`FORMAT_OTHER`	-	Available Choices: [0] Set Date [1] Set Date and Time [2] SAGA Date Field Type [3] Julian Day Number (JDN) [4] Modified Julian Day Number (MJD) [5] Unix Timestamp Default: 0
	Other Date	date [GUI]	`DATE_OTHER`	-	Default: 2026-02-24
	Other Time	text [GUI]	`TIME_OTHER`	-	Default: 17:40:20
	Other ISO Time	text	`ISOTIME_OTHER`	-	Default: 2026-02-23T17:40:20
	Range Begin Field	table field	`FIELD_BEGIN`	-	-
	Range BeginFormat	choice	`FORMAT_BEGIN`	-	Available Choices: [0] Set Date [1] Set Date and Time [2] SAGA Date Field Type [3] Julian Day Number (JDN) [4] Modified Julian Day Number (MJD) [5] Unix Timestamp Default: 0
	Range Begin Date	date [GUI]	`DATE_BEGIN`	-	Default: 2026-02-24
	Range Begin Time	text [GUI]	`TIME_BEGIN`	-	Default: 17:40:20
	Range Begin ISO Time	text	`ISOTIME_BEGIN`	-	Default: 2026-02-23T17:40:20
	Range End Field	table field	`FIELD_END`	-	-
	Range EndFormat	choice	`FORMAT_END`	-	Available Choices: [0] Set Date [1] Set Date and Time [2] SAGA Date Field Type [3] Julian Day Number (JDN) [4] Modified Julian Day Number (MJD) [5] Unix Timestamp Default: 0
	Range End Date	date [GUI]	`DATE_END`	-	Default: 2026-02-24
	Range End Time	text [GUI]	`TIME_END`	-	Default: 17:40:20
	Range End ISO Time	text	`ISOTIME_END`	-	Default: 2026-02-23T17:40:20

Command Line


Usage: saga_cmd table_tools 31 [-TABLE ] [-OUTPUT ] [-FIELD_TIMEPOINT ] [-FORMAT_TIMEPOINT ] [-ISOTIME_TIMEPOINT ] [-OPERATION ] [-BOOL_AS ] [-TRUE_STRING ] [-FALSE_STRING ] [-FIELD_OTHER ] [-FORMAT_OTHER ] [-ISOTIME_OTHER ] [-FIELD_BEGIN ] [-FORMAT_BEGIN ] [-ISOTIME_BEGIN ] [-FIELD_END ] [-FORMAT_END ] [-ISOTIME_END ]
  -TABLE:               Table
	table, input
  -OUTPUT:              Output
	table, output, optional
  -FIELD_TIMEPOINT:     Timepoint Field
	table field
  -FORMAT_TIMEPOINT:
                             TimepointFormat 
                             	choice
                             	Available Choices:
                             	[0] Set Date
                             	[1] Set Date and Time
                             	[2] SAGA Date Field Type
                             	[3] Julian Day Number (JDN)
                             	[4] Modified Julian Day Number (MJD)
                             	[5] Unix Timestamp
                             	Default: 0
  -ISOTIME_TIMEPOINT:   Timepoint ISO Time
	text
	Default: 2026-02-23T17:40:20
  -OPERATION:
                             Logical Operation
                             	choice
                             	Available Choices:
                             	[0] Is Earlier Than
                             	[1] Is Equal To
                             	[2] Is Later Than
                             	[3] Is Same Date
                             	[4] Is Same Time
                             	[5] Is Between
                             	[6] Is Strictly Between
                             	[7] Is Leap Year
                             	[8] Is Daylight Saving Time
                             	Default: 0
  -BOOL_AS:             Output
	choice
	Available Choices:
	[0] Bool
	[1] String
	Default: 0
  -TRUE_STRING:         True String
	text
	Default: true
  -FALSE_STRING:        False String
	text
	Default: false
  -FIELD_OTHER:         Other Field
	table field
  -FORMAT_OTHER:
                             OtherFormat 
                             	choice
                             	Available Choices:
                             	[0] Set Date
                             	[1] Set Date and Time
                             	[2] SAGA Date Field Type
                             	[3] Julian Day Number (JDN)
                             	[4] Modified Julian Day Number (MJD)
                             	[5] Unix Timestamp
                             	Default: 0
  -ISOTIME_OTHER:       Other ISO Time
	text
	Default: 2026-02-23T17:40:20
  -FIELD_BEGIN:         Range Begin Field
	table field
  -FORMAT_BEGIN:
                             Range BeginFormat 
                             	choice
                             	Available Choices:
                             	[0] Set Date
                             	[1] Set Date and Time
                             	[2] SAGA Date Field Type
                             	[3] Julian Day Number (JDN)
                             	[4] Modified Julian Day Number (MJD)
                             	[5] Unix Timestamp
                             	Default: 0
  -ISOTIME_BEGIN:       Range Begin ISO Time
	text
	Default: 2026-02-23T17:40:20
  -FIELD_END:           Range End Field
	table field
  -FORMAT_END:
                             Range EndFormat 
                             	choice
                             	Available Choices:
                             	[0] Set Date
                             	[1] Set Date and Time
                             	[2] SAGA Date Field Type
                             	[3] Julian Day Number (JDN)
                             	[4] Modified Julian Day Number (MJD)
                             	[5] Unix Timestamp
                             	Default: 0
  -ISOTIME_END:         Range End ISO Time
	text
	Default: 2026-02-23T17:40:20