Date and Time Handling

When you create a query containing date fields, the default display in PeopleSoft Pure Internet Architecture is based on the regional setting. For example, if the personalization setting uses date format MMDDYY and date separator /, the date is displayed as MM/DD/YYYY.

See Global Technology: Defining User-Specific, Locale-Based Formatting.

When you execute the query using one of the QAS service operations, date and time are returned in the following way:

• Date is returned to the client applications as YYYY-MM-DD. For example, April 6, 2009 is 2009-04-06.

• Time is returned as hh:mm:ss.milliseconds. For example, 9:30 a.m. is returned as 9:30:00.000000.

• Datetime is returned with the UTC (coordinated universal time) offset for the base time zone. For example, if the base time zone is PDT (Pacific Daylight Time), then April 6, 2009 9:30 a.m. is returned as 2009-04-06T09:30:00-0700.

If a date field is used as a prompt, the FieldValue must be entered as YYYY-MM-DD in the QAS execution request.