Parameters

-a
Use to display database values and date strings for date fields. For example, to display the database value for the date 9/1/99, enter: 
arsdate -a 9/1/99
The ARSDATE program returns: 
9/1/99 -> 10836
To display the date string for the database value 10836 in the default date format, enter: 
arsdate -a 10836
The ARSDATE program returns: 
10836 -> 9/1/99
-A
Output date type (defaults to input type)
-i
Use to display database values and date and time strings for Date (old style), Date/Time (old style), Date/Time (TZ) (old style), and Time (old style) fields. The time part of the Date/Time (old style) and Date/Time (TZ) (old style) fields is not adjusted for the local time zone. You typically use the -i parameter to find out one of two things:
  • Given a date and time printed on a report, what value did Content Manager OnDemand store in Date (old style), Date/Time (old style), Date/Time (TZ) (old style), or Time (old style) database field? You can use the result to search a date or time field with an SQL string.
  • Given a value stored in a Date (old style), Date/Time (old style), Date/Time (TZ) (old style), or Time (old style) database field, what would be the date and time printed on a report?
-I
Output date/time type (without timezone)
-z
Use to display database values and date and time strings for Date/Time (TZ) (old style) fields. The time part of a Date/Time (TZ) (old style) field is adjusted for the local time zone. If you run the ARSDATE program with the -z parameter on systems in different time zones and you specify the same date and time value, the result will be different. For example, suppose that you need to determine the value stored in a Date/Time (TZ) (old style) field for "09/01/00 04:00:00". The command: 
arsdate -z "09/01/00 04:00:00"
When run on a server in the Eastern time zone will return: 
09/01/00 04:00:00 -> 936187200
If you run the same command on a server in the Mountain time zone, then result will be: 
09/01/00 04:00:00 -> 936180000
A typical use of the -z parameter is to determine a database value with which to search the system log. You can use the result to search the Date/Time (TZ) (old style) field of the system log with an SQL string. For example, suppose a user in New York logs on to a server in Denver. To retrieve the log on messages with an SQL string, you must specify the date and time part of the query using the local time of the client that is running the query. If the user logged on to the server at 4 a.m. Eastern time, then a query that is run in Denver must specify 2 a.m. to retrieve the message.
-Z
Output date/time type (with timezone)
-C
Convert to/from Content Manager OnDemand internal type and database type
-d days
Add the specified number of days to the specified internal value.
-D
Database type (default is Content Manager OnDemand internal type)
-f input_fmt
Determines the format of the date and time string that Content Manager OnDemand displays.

Table 1 lists the standard date and time formats that are supported by Content Manager OnDemand. If the input data contains a date or time format that is not listed in the table, you can specify the format to Content Manager OnDemand. However, when specifying a format, you can only use values and separators from the standard formats that are listed in the table. Date and time formats may also be specified on the Load Information page in the application and the Field Information page in the folder.

The format consists of a set of values (for example, %m) and separators (such as the slash, dash, colon, or dot characters). A specification for a date format that uses any of these three chars (/ - .) can be used interchangeably; the program allows any of the three, regardless of which one you specified in the date format. A specification for a time format that uses either of these two chars (: .) can be used interchangeably; the program allows either of the two, regardless of which one you specified in the time format.

Table 1. Date and time format specifications
Date Format Specifier Date Format Example
%m/%d/%y mm/dd/yy 01/31/17
%d/%m/%y dd/mm/yy 31/01/17
%f/%e/%y m/d/yy 1/31/17
%e/%f/%y d/m/yy 31/1/17
%y.%m.%d yy.mm.dd 17.01.31
%m.%d.%Y mm.dd.yyyy 01.31.2017
%m-%d-%y mm-dd-yy 01-31-17
%d-%m-%y dd-mm-yy 31-01-17
%m%d%y mmddyy 013117
%m%d%Y mmddyyyy 01312017
%y%m%d yymmdd 170131
%Y%m%d yyyymmdd 20170131
%b %e, %Y Mth d, yyyy Jan 31, 2017
%B %e, %Y Month d, yyyy January 31, 2017
%m/%d/%y %H:%M mm/dd/yy hh:mm 01/31/17 10:50
%H:%M hh:mm 10:50
%T hh:mm:ss 10:50:59
%H.%M hh.mm 10.50
%T hh.mm.ss 10.50.59
-F output_fmt
Output format string
-g
Display the current system date.
-h hours
Add the specified number of hours to the specified internal value.
-m months
Add the specified number of months to the specified internal value.
-n minutes
Add the specified number of minutes to the specified internal value.
-s seconds
Add the specified number of seconds to the specified internal value.
-t
Use to display database values and time strings for Time fields. The time is not adjusted for the local time zone. For example, to display the database value for the time 04:00:00, enter: 
arsdate -t 04:00:00
The ARSDATE program returns: 
04:00:00 -> 4800
To display the time string for the database value 4800, enter: 
arsdate -t 4800
The ARSDATE program returns: 
4800 -> 04:00:00
-y years
Add the specified number of years to the specified internal value.
-1 trace_file
Specify a fully qualified trace file name as directed by IBM Software Support.
-2 level
Specify a numeric value as directed by IBM Software Support.
Parent topic: ARSDATE