Dates in PS Query
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Dates in PS Query
| Line 11: | Line 11: | ||
<pre>add_months(to_date(A.EFFDT,'YYYY-MM-DD'),-12)</pre> | <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. | 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] | ||
| + | |||
| + | |} | ||
