Date Transformation Functions - Page 1

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

www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License