Setup and Installation › How to Set up Remedy for Connection to CA Clarity PPM › rem:timestamp - Generating Remedy Web Service Time Values

rem:timestamp - Generating Remedy Web Service Time Values

Remedy Web Service takes some data in its own format; use the rem:timestamp tag to simplify date conversions.

mode

Required. This can be "DATE_TO_LONG" or "FORMAT_TIMEZONE".

In Remedy, when a date, including time, is to be used as a query condition, instead of: date > to_date("2005-01-2 12:23:12")

Remedy uses: date > 10234420304

This provides the number of seconds since midnight of Jan. 1st, 1970. Use mode="DATE_TO_LONG" to get a number that is based upon a date.

In Remedy, when a date is obtained from a web service, it exists in the following format: 2005-04-01T13:44:12-08:00, where "-08:00" at the end specifies the time zone and can only be understood by SimpleDateFormat (which is used in the <gel:parseDate> tag). Use mode=" FORMAT_TIMEZONE" to generate a date string that is understandable by <gel:parseDate>.

Type: String

var

Required. The variable referred by this name contains the result:

• If mode="DATE_TO_LONG", it is a Long.
• If mode="FORMAT_TIMEZONE"), it is a string.

Type: String

value

Required. The value to be converted:

• If mode="DATE_TO_LONG", it is a date.
• If mode="FORMAT_TIMEZONE", it is a string.

Type: Expression

Example

<rem:timestamp var="LastRemedyIncidentTime1" value="${LastRemedyIncidentTime}" mode="FORMAT_TIMEZONE"/>
      <gel:parseDate dateVar="RDate" stringVar="LastRemedyIncidentTime1" format="yyyy-MM-dd'T'HH:mm:ssZ"/>
      <rem:timestamp var="RemedyTime" value="${RDate}" mode="DATE_TO_LONG"/>