- 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" ...
- 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
- 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