Row timestamp - Connect_CDC - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Method: Row timestamp

Function name: rowoptime

Parameter list: none

Return type:   CHAR

What the method does: The implied input is the current data row. Returns the date and time at which the iSeries update operation occurred. Time is GMT, including fractions of a second. 

Uses the following format:

YYYYMMDDHHMMSSffffff

where:

  • YYYY–the year (for example, 2010)

  • MM–the month (for example, 06 for June)

  • DD–the date (for example, 25)

  • HH–the hour in a 24-hour clock (for example, 20 for 8:00 pm).

  • MM–the minute

  • SS–the seconds

  • ffffff–is fractions of a second

There are no inputs for this method.

Note: All 6 digits (for System i5 and SQL Server) contain fractional digits that are accurate to 6 digits. Other databases fractional digits may be padded with up to 6 zeros so that all timestamps for all databases total 20 digits.