Examples

  1. The following example shows how to determine the database value for the specified date and time string. The data type of the database field is Date/Time (old style).
        arsdate -i "09/01/99 04:00:00"
    
        09/01/99 04:00:00 -> 936158400
    In the example, you could use the database value to search a Date/Time (old style) field in the database with an SQL string. For example:
        arsdoc get -i "WHERE somedate=936158400" ...
  2. The following example shows how to determine the date and time string for the specified database value. The data type of the database field is Date/Time (old style). The result is shown using the default display format.
        arsdate -i 936158400
    
        936158400 -> 09/01/99 04:00:00
  3. The following example shows how to determine the database value for the specified date and time string. The data type of the database field is Date/Time (TZ) (old style). The ARSDATE program adjusts the time part of the result for the local time zone.
        arsdate -z "09/01/99 04:00:00"
    
        09/01/99 04:00:00 -> 936180000
    If you were to run the same command on a server in the Eastern time zone, the result would be:
        arsdate -z "09/01/99 04:00:00"
    
        09/01/99 04:00:00 -> 936187200