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
On this page of the site you can watch the video online PSQuery Date Math with a duration of hours minute second in good quality, which was uploaded by the user PeopleTools Tech Tips 26 March 2024, share the link with friends and acquaintances, this video has already been watched 449 times on youtube and it was liked by 14 viewers. Enjoy your viewing!
