PSQuery Date Math
Date Math in PSQuery
Working with dates in PSQuery can be frustrating unless you understand PeopleSoft
MetaSQL functions for manipulating dates. Copy and pasting working SQL from a SQL Tool usually fails spectacularly in PSQuery...
...Unless you know how to use the Meta-SQL
Jump to specific sections:
00:00 Intro
01:00 Why valid SQL date expressions don't work in PSQuery
02:50 Today
03:18 Now
03:45 %DateIn()
04:39 %DateTimeIn()
05:11 %DateDiff()
06:34 Oracle SQL Date Diff in PSQuery
06:54 %DateAdd()
08:13 %DatePart()
09:50 Date Expression as Criteria
10:25 Wrap Up
PeopleBooks MetaSQL Refrence: https://docs.oracle.com/cd/F82753_01/...
MetaSQL functions covered in this video:
%CurrentDateIn
%CurrentDateTimeIn
%DateIn()
%DateTimeIn()
%DateDiff()
%DateAdd()
%DatePart()
... and useing PSQuery MetaSQL expressions in the Criteria section.
PeopleTools Tech Tips: https://peopletoolstechtips.com/psque...
Production Notes:
A PT3 Production
Presenter: Randall Groncki
Camera Kid: Anjelica Groncki
Music: Vlad Gluschenko — Overseas
License: CC BY 3.0: https://creativecommons.org/licenses/...
/ @vladgluschenkomusic