System reserved words
System reserved words begin with ss. All of them deal with date values. The offsets are all in relation to today. These words are used usually on the where clause or in expressions or in manual SQL dictionary words.
Synonyms
Examples
Reserved word | Description |
ss.begcurweek | ![]() begin of current week (Sunday) |
ss.begmon | ![]() begin of current month |
ss.begmonth | ![]() ![]() date1 = begin of current month plus 5 months. date2 = begin of current month minus 2 months. |
ss.begnxtmon | ![]() begin of next month |
ss.begnxtweek | ![]() begin of next week |
ss.begprvmon | ![]() begin of previous month |
ss.begprvweek | ![]() begin of previous week (Sunday) |
ss.begweek | ![]() ![]() date1 = begin of current week plus 2 weeks. date2 = begin of current week minus 8 weeks. |
ss.begyear | ![]() ![]() date1 = begin of current year plus 1 year. date2 = begin of current year minus 2 years. |
ss.days | ![]() ![]() date1 = today plus 60 days. date2 = today minus 30 days. |
ss.endmon | ![]() last day of current month |
ss.endmonth | ![]() ![]() date1 = end of current month plus 5 months. date2 = end of current month minus 2 months. |
ss.endnxtmon | ![]() last day of next month |
ss.endnxtweek | ![]() end of next week (Saturday) |
ss.endprvmon | ![]() last day of previous month |
ss.endprvweek | ![]() end of previous week (Saturday) |
ss.endweek | ![]() ![]() date1 = end of current week plus 2 weeks. date2 = end of current week minus 8 weeks. |
ss.endyear | ![]() ![]() date1 = end of current year plus 1 year. date2 = end of current year minus 2 years. |
ss.months | ![]() ![]() date1 = today plus 24 months. date2 = today minus 36 months. |
ss.sysdte![]() |
![]() today |
Page 1 — Quiz words
Page 2 — Operators
Page 3 — Where words
Page 4 — Print words
Page 5 — Sort words
Page 6 — Chart words
Page 7 — Expression words
Page 8 — System words
Page 9 — Global words
Next – Global words >