DatePart
Syntax
DatePart(datetime_value)
Description
Use the DatePart function to determine a date based on a provided DateTime value.
Returns
Returns a Date value equal to the date part of a specified DateTime value.
DateTime6
Syntax
DateTime6(year, month, day, hour, minute, second)
Description
The DateTime6 function returns a DateTime value based on integer values for the year , month , day , hour , minute , and second . If the result of this function is not an actual date, there is a runtime error.
Warning! Make sure that you ...
DateTimeToHTTP
Syntax
DateTimeToHTTP(datetime)
Description
Use the DateTimeToHTTP function to convert any DateTime value to a date/time string in the format specified by HTTP 1.0 and 1.1 standards.
Note: Because the HTTP protocol is used to interchange information between diverse computing systems, the value returned from this function ...
DateTimeToISO
Syntax
DateTimeToISO(textdatetime)
Description
Use the DatetimeToISO function to convert the text value textdatetime (as a base time zone time) to a DateTime value in ISO 8601 format. This function automatically calculates whether daylight saving time is in effect for the given textdatetime.
The systemâs base time zone is ...
DateTimeToLocalizedString
Syntax
DateTimeToLocalizedString({datetime | date}, [Pattern])
Description
Use the DateTimeToLocalizedString function to convert either datetime or date to a localized string. You can also specify a particular pattern to convert datetime or date to.
The Pattern is optional. Only specify Pattern if necessary.
If you need to change the pattern for ...
DateTimeToTimeZone
Syntax
DateTimeToTimeZone(OldDateTime, SourceTimeZone, DestinationTimeZone)
Description
Use the DateTimeToTimeZone function to convert DateTime values from the DateTime specified by SourceTimeZone to the DateTime specified by DestinationTimeZone .
Parameters
|
Field or Control |
Definition |
|---|---|
| OldDateTime |
Specify the DateTime value to be converted. |
| SourceTimeZone |
Specify the time zone that OldDateTime is in. Valid values ... |
DateTimeToUserFormat
Syntax
DateTimeToUserFormat(textdatetime, {timezone | "Local" | "Base"})
Description
Use the DateTimeToUserFormat function to convert the string value textdatetime in PeopleSoft internal date/time format to a date/time value in the user's personalized date/time format for a specified time zone.
The format for the return value is determined in ...
DateTimeValue
Syntax
DateTimeValue(textdatetime)
Description
Use the DateTimeValue function to derive a DateTime value from a string representing a date and time.
Parameters
|
Field or Control |
Definition |
|---|---|
| textdatetime |
Specify a date/time value represented as text in one of three formats:
|
DateValue
Syntax
DateValue(date_str)
Description
Use the DateValue function to convert a date string and returns the result as a Date type. date_str must be a string in the active date format user's current personalization date format.
If the user's Date Format personalization setting is set to DDMMYY (or ...