WikiSysop: 1 revision imported

2016-03-25T08:51:09Z

1 revision imported

WikiSysop at 22:14, 28 August 2015

2015-08-28T22:14:29Z

New page

[[PeopleSoft Query]] surrounds dates and datetimes from the database with a conversion to consistent format. This is similar to the effect of the PeopleCode %DateOut, %TimeOut and %DateTimeOut. The effect of this can be seen when you preview the SQL.

The date functions are particular to the database in use. For instance in Oracle:

<pre>to_char(A.EFFDT,'YYYY-MM-DD')</pre>
The conversion to char means that the date functions will not work natively. You can convert this back to date by creating an expression as follows:

<pre>to_date(A.EFFDT,'YYYY-MM-DD')</pre>
This means that you can then use date functions:

<pre>add_months(to_date(A.EFFDT,'YYYY-MM-DD'),-12)</pre>
Note that DateTimes can be converted differently and so care is needed when mixing data types.

==More About Functions==

{| class="wikitable"
|-
|[[File:UsingFunctionsInPeopleSoftQuerySmall.jpg|90px|link=http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21]]

|For more information about functions in [[PeopleSoft Query]] and some other interesting stuff too, read our eBook:

[http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21 Using Functions in PeopleSoft Query]

|}

← Older revision	Revision as of 08:51, 25 March 2016
(No difference)

Dates in PS Query - Revision history

WikiSysop: 1 revision imported

WikiSysop at 22:14, 28 August 2015