Weekday() mvSQL database function in Jitterbit App Builder

Summary

Returns weekday of date between 1 (Sunday) and 7 (Saturday).

Syntax

WEEKDAY(<date>)

Parameters

date

The date to evaluate.

Returns

The weekday of the given date.

Examples

WEEKDAY('05/11/15')

Returns

2 since 05/11/15 was a Monday.