PSQuery Date Math

Publicado el: 26 marzo 2024
en el canal de: PeopleTools Tech Tips

449

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

En esta página del sitio puede ver el video en línea PSQuery Date Math de Duración hora minuto segunda en buena calidad , que subió el usuario PeopleTools Tech Tips 26 marzo 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 449 veces y le gustó 14 a los espectadores. Disfruta viendo!

915