BEFORE - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine
Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T20:19:56.898694

The BEFORE function returns the value of a date, time or timestamp resulting from subtracting a specified number of days, months, years, minutes, hours and/or seconds or years from a source date.

Category

Date / Time

Syntax 
BEFORE(<date> | <time> | <timestamp>, ['nYY], [nMM], [nDD], [nHH], [nMI], [nSS]' )
Parameters and Descriptions
Parameter Description
date

This parameter specifies a source date in YYYYMMDD format.
time

This parameter specifies a source time in HHMMSS format or the source timestamp in YYYYMMDDHHMMSS format.
timestamp
This parameter specifies a timestamp in YYYYMMDDHHMMSS format.
  • [n’YY]' - Specifies the number of years, n, to be added to the date/time value.

  • [n’MM]' - Specifies the number of months, n, to be added to the date/time value.

  • [n’DD]' - Specifies the number of days, n, to be added to the date/time value.

  • [n’HH]' - Specifies the number of hours, n, to be added to the date/time value.

  • [n’MI]' - Specifies the number of minutes, n, to be added to the date/time value.

  • [n’SS]' - Specifies the number of seconds, n, to be added to the date/time value.

Example

Subtract 5 years, 3 months and 2 days from the date 03/01/2006, which is in field SRC_DATE, and map it to target field TGT_DATE.

TGT_DATE = BEFORE (SRC_DATE, '5YY', '3MM', '2DD')

The result is a date value of 11/27/2001 in field TGT_DATE.