Select - Datetime

Select templates for variable length binary fields, of type varbinary.   Click on a template's link to jump to that template's topic.

 

Expression

Select using the given expression.

Null

Select for null values in the source field.

 

  • null - Select records with NULL values.
  • not null - Select records with non-NULL values.

 

Search

Select by making comparisons against the desired extraction from the datetime field specified in the Use parameter, using the given Condition,  compared to the given value or values,  which can be values from a field, a specified value, or the result of an expression that evaluates to a numeric value or to a datetime value depending on the data type of the extraction specified in the Use parameter.

 

Use options:

 

  • date and time - Use the full datetime values in the source field.  
  • date without time - Use the datetime values in the source field but setting all time portions of the data time value to zero.  For example, the date without time result for 12/25/2016 13:43:53 would be 12/25/2016 0:00:00.  
  • day - Use the day of the month number of the datetime values in the source field.     For example, the day of the month number for a datetime value of 12/25/2016 13:43:53 would be 25.  
  • hour - Use the hour of the day number, using 24 hour format, of the datetime values in the source field.     For example, the hour of the day number for 12/25/2016 13:43:53 would be 13.  
  • millisecond - Use the millisecond number of the datetime values in the source field.   Many data sets do not bother recording greater time detail than seconds, so the millisecond number of datetime values is often zero.
  • minute - Use the minute of the hour number of the datetime values in the source field.     For example, the minute of the hour number for 12/25/2016 13:43:53 would be 43.  
  • month - Use the month of the year number of the datetime values in the source field.     For example, the month of the year number for 12/25/2016 13:43:53 would be 12.  
  • second - Use the second of the minute number of the datetime values in the source field.     For example, the second of the minute number for 12/25/2016 13:43:53 would be 53.  
  • week - Use the computed week of the year number of the datetime values in the source field.   Choosing the week option will open a Week start parameter box allowing specification of the day of the week (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday) on which a week is considered to begin.  Choosing a different Week start day will often change the computed week of the year.   For example, 12/25/2016 13:43:53 falls on a Sunday.  The week of the year number for 12/25/2016 13:43:53 using a Week start day of Sunday would be 53.   Using a Week start day of Monday for that same datetime value would result in a week of the year number of 52.  
  • week day - Use the computed day of the week number, from 1 to 7,  of the datetime values in the source field.   Choosing the week day option will open a Week start parameter box allowing specification of the day of the week (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday) on which a week is considered to begin.  Choosing a different Week start day will often change the computed day of the week number.  For example, 12/25/2016 13:43:53 falls on a Sunday.  The day of the week number for 12/25/2016 13:43:53 using a Week start day of Sunday would be 1.   Using a Week start day of Monday for that same datetime value would result in a day of the week number of 7.  
  • year - Use the year number of the datetime values in the source field.     For example, the year number for 12/25/2016 13:43:53 would be 2016.  
  • year day - Use the computed day of the year number, from 1 to 365, of the datetime values in the source field.   For example, the day of the year number for 12/25/2016 13:43:53 would be 360.   

 

Condition options:

 

  • between - Select records with values between the specified At least and At most values, inclusive.
  • equal (=) - Select records with values equal to the specified value.
  • greater (>) - Select records with values greater than the specified value.
  • greater or equal (>=) - Select records with values greater than or equal to the specified value.
  • less (<) - Select records with values less than the specified value.
  • less or equal (<=) - Select records with values less than or equal to the specified value.
  • not equal (<>) - Select records with values not equal to the specified value.

 

If we would like to select records that are logical NOT variations of the above, for example not between, select on the basis of one of the above and press Ctrl-I or Edit - Select Inverse to invert the selection.   Selecting using between and then pressing Ctrl-I is the equivalent of "not between" the given values.

 

 

See Also

Select - Datetime: Expression

 

Select - Datetime: Null

 

Select - Datetime: Search

 

Select Reference

 

Select - Expression

 

Select - Binary

 

Select - Boolean

 

Select - Geometry

 

Select - Numbers

 

Select - Numeric Vectors

 

Select - Text

 

Select - Tiles

 

Select - UUID