%DateIn
When a date literal or a date bind variable is used within the WHERE clause of SELECT or UPDATE statements,
it can be specified within the %DateIn meta-SQL variable to get the platform-specific SQL syntax for the date.
%Datein resolves to to_date('2013-06-10','YYYY-MM-DD')
In short it converts the date literal / bind variable into the format which the DB uses.
INSERT INTO PS_SGK_REC (EMPLID, NAME, JOIN_DT, DEPTID)
VALUES (’001′, ‘John’, %DateIn(:1), ‘EAS’);
-------------------------------------------------------------------------------------------
%DateOut
%DateOut on the other hand converts a date column in the SELECT clause to the format that PeopleSoft uses.
SELECT EMPLID, NAME, %DateOut(JOIN_DT)
FROM PS_SGK_REC WHERE DEPTID = ‘EAS’;
%Dateout resolves to to_char(date,'YYYY-MM-DD')
Local Rowset &rs = Createrowset(Record.PERSON);
&rs.Fill("WHERE 1=0 UNION SELECT EMPLID, %DateOut(BIRTHDATE),BIRTHPLACE,BIRTHCOUNTRY,
BIRTHSTATE,%DateOut(DT_OF_DEATH),%DateTimeOut(LAST_CHILD_UPDDTM)
FROM PS_PERSON WHERE EMPLID = :1", &emplid);
------------------------------------------------------------------------------------------------
%SELECTALL
%SelectAll uses the underlying record definition to select the fields - so it will always return all fields from the underlying record, even if that record definition changes.
Local Record &REC ;
&REC = CreateRecord(Record.SF_ACCTG_LN);
&SQL = CreateSQL("%SELECTALL(:1) WHERE GL_DISTRIB_STATUS =:2 AND ACCOUNTING_DT <=TO_DATE( :3 ,'YYYY-MM-DD') ", &REC, "N", IBT_GL_RUN_AET.END_DATE);
While &SQL.Fetch(&REC)
&Currency_cd = &REC.CURRENCY_CD.Value ;
&account = &REC.ACCOUNT.Value
End-While
