Dates in PS Query - Revision history

WikiSysop at 22:14, 28 August 2015

2015-08-28T22:14:29Z

← Older revision		Revision as of 22:14, 28 August 2015
Line 14:		Line 14:
	==More About Functions==		==More About Functions==

-	For more information about functions in [[PeopleSoft Query]], ~~get a copy of~~ our eBook:	+	{\| 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]		[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]
		+
		+	\|}

WikiSysop at 21:36, 25 August 2015

2015-08-25T21:36:07Z

← Older revision		Revision as of 21:36, 25 August 2015
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==
		+
		+	For more information about functions in [[PeopleSoft Query]], get a copy of 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]

WikiSysop at 15:09, 11 August 2013

2013-08-11T15:09:15Z

← Older revision		Revision as of 15:09, 11 August 2013
Line 3:		Line 3:
	The date functions are particular to the database in use. For instance in Oracle:		The date functions are particular to the database in use. For instance in Oracle:

-	<pre>to_char(A.EFFDT,'YYYY-MM-DD')<\pre>	+	<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:		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:

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

-	add_months(to_date(A.EFFDT,'YYYY-MM-DD'),-12)	+	<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.

WikiSysop at 15:07, 11 August 2013

2013-08-11T15:07:39Z

← Older revision		Revision as of 15:07, 11 August 2013
Line 1:		Line 1:
-	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.	+	[[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:		The date functions are particular to the database in use. For instance in Oracle:

-	to_char(A.EFFDT,'YYYY-MM-DD')	+	<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:		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:

WikiSysop at 15:05, 11 August 2013

2013-08-11T15:05:54Z

← Older revision		Revision as of 15:05, 11 August 2013
Line 1:		Line 1:
-
	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.		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.

WikiSysop: Created page with " 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 %..."

2013-08-10T20:50:07Z

Created page with " 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 %..."

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:

to_char(A.EFFDT,'YYYY-MM-DD')
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:

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

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