pdate()

dateExp

Expression whose result is a date, or of standard date format

@w

Take Sunday as the first day of a week and get the first day of the week to which dateExp belongs; this is the default option of pdate() function

@1

Work with @w option and take Monday as the first day of a week; note that it is number 1 that is used here

@m

Get the first day of the month to which dateExp belongs

@q

Get the first day of the quarter to which dateExp belongs

@y

Get the first day of the year to which dateExp belongs

@e

Work with another option to get the last day

pdate@w(datetime("19800227","yyyyMMdd"))

1980-02-24; get the first day of the week to which the parameter belongs.

pdate@we (datetime("19800227","yyyyMMdd"))

1980-03-01; get the last day of the week to which the parameter belongs.

pdate@w1(datetime("19800227","yyyyMMdd"))

1980-02-25; take Monday as the first day of a week and get the first day of the week to which the parameter belongs.

pdate@m(datetime("19800227","yyyyMMdd"))

1980-02-01; get the first day of the month to which the parameter belongs.

pdate@me(datetime("19800227","yyyyMMdd"))

1980-02-29; get the last day of the month to which the parameter belongs.

pdate@q(datetime("19800227","yyyyMMdd"))

1980-01-01; get the first day of the quarter to which the parameter belongs.

pdate@qe(datetime ("19800227","yyyyMMdd"))

1980-03-31; get the last day of the month to which the parameter belongs.

pdate@y(datetime("19800227","yyyyMMdd"))

1980-01-01; get the first day of the year to which the parameter belongs.

pdate@ye(datetime("19800227","yyyyMMdd"))

1980-12-31; get the last day of the month to which the parameter belongs.