Date Transformation Functions - Page 1

Date transformation functions in Advanced ETL Processor allow you to modify, convert, compare, and validate date values during data transformation. Use these functions to change date components, calculate differences between dates, extract date parts, convert Unix/Epoch timestamps, format dates, and apply conditional transformations based on days, weeks, months, quarters, or date ranges.

Download Advanced ETL Processor

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Change Date

Changes part of a date

Change Date Dynamic

Changes part of date

Current Date

Returns current date in ‘yyyy-mm-dd hh:nn:ss.fff' format

Date Diff

Calculates difference of two dates

Date Format

Returns Date in yyyy-mm-dd hh:nn:ss.fff format

Date Part

Returns part of a date value (day, month, year...)

Date to Epoch

Converts Date to Epoch(Unix) Format

Epoch to Date

Converts Epoch (Unix Date) to Date

If 1st Quarter, If 2nd Quarter, If 3rd Quarter, If 4th Quarter, If Current Quarter, If Last Quarter, If Next Quarter

Checks if the data is a Date value which belongs to specific Quarter

If Current Week, If Last Week, If Next Week

Checks if the data is a Date value which belongs to specific week

If Date

Checks if the data is a Date

If Date Between

Checks if the data is a Date between two values

If Date Less Than

Checks if the data is a Date less than value

If Date More Than

Checks if the data is a Date more than value

If January, If February, If March, If April, If May, If June, If July, If August, If September, If October, If November, If December, If Current Month, If Last Month, If Next Month

Checks if the data is a Date value which belongs to specific Month

Advanced-etl-processor

Date Transformation Functions - Page 1

Download Advanced ETL Processor