Sending DateTime Data to an Adapter Configuration
When TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) publishes messages including datetime data, the wire format is handled implicitly since because Publication Service and Subscription Service use the same format.
Messages containing datetime data sent to the adapter must have that data in a string format. By formatting dates as strings, the adapter handles date values outside the range supported by RVMSG_DATETIME, January 1, 1970 to January 1, 2034. The adapter TRA properties also include a few date and time patterns that you can specify to use.
adbDateTime Object
To view the structure of the adbDateTime object, go to the Project Explorer view, and expand .
The adapter returns an error when the input data contains timezone information. You can use the TIBCO BusinessWorks XPath function to parse the time zone information before the information is passed to the adapter.
Specifying Date and Time Patterns
- adb.datePattern: the date format pattern for java.text.SimpleDateFormat. The default format is yyyy-MM-dd.
- adb.timePattern: the time format pattern for java.text.SimpleDateFormat. The default format is HH:mm:ss.
- adb.timestampPattern: the standard timestamp format pattern for java.text.SimpleDateFormat. The default format is yyyy-MM-dd HH:mm:ss.S.