Ansicht
Dokumentation
ABENDDIC_DATE_TIME_FUNCTIONS - DDIC DATE TIME FUNCTIONS
Addresses (Business Address Services) CPI1466 during BackupThis documentation is copyright by SAP AG.
- Date Functions and Time Functions
The following table shows the date and time functions that can be used by ABAP CDS and . The last three columns indicate where a function can be used.
| SQL Function | Result | ABAP CDS, DDIC-Based Views | ABAP CDS, View Entities | |
| ABAP_SYSTEM_TIMEZONE | System time zone in AS ABAP. | x | x | x |
| ABAP_USER_TIMEZONE | User time zone in AS ABAP. | x | x | x |
| ADD_DAYS | Adds days to a date. | x | ||
| ADD_MONTHS | Adds months to a date. | x | ||
| DATN_ADD_DAYS | Adds days to a date. | x | x | x |
| DATN_ADD_MONTHS | Adds months to a date. | x | x | x |
| DATN_DAYS_BETWEEN | Difference between two dates. | x | x | x |
| DATS_ADD_DAYS | Adds days to a date. | x | x | x |
| DATS_ADD_MONTHS | Adds months to a date. | x | x | x |
| DATS_DAYS_BETWEEN | Difference between two dates. | x | x | x |
| DATS_FROM_DATN | Converts a date from type DATN to type DATS. | x | x | x |
| DATS_IS_VALID | Shows whether the argument is a valid date. | x | x | x |
| DATS_TIMS_TO_TSTMP | Time stamp for a local date and a local time. | x | x | x |
| DATS_TO_DATN | Converts a date from type DATS to type DATN. | x | x | x |
| DAYNAME | Shows the name of a day of a date. | x | ||
| DAYS_BETWEEN | Difference between two dates. | x | ||
| EXTRACT_DAY | Extracts the day of a date. | x | ||
| EXTRACT_HOUR | Extracts the hour of a time. | x | ||
| EXTRACT_MINUTE | Extracts the minute of a time. | x | ||
| EXTRACT_MONTH | Extracts the month of a date. | x | ||
| EXTRACT_SECOND | Extracts the second of a time. | x | ||
| EXTRACT_YEAR | Extracts the year of a date. | x | ||
| IS_VALID | Shows whether the argument is a valid date, time, or time stamp. | x | ||
| MONTHNAME | Shows the name of a month of a date. | x | ||
| TIMS_FROM_TIMN | Converts a time from type TIMN to type TIMS. | x | x | x |
| TIMS_IS_VALID | Shows whether the argument is a valid time. | x | x | x |
| TIMS_TO_TIMN | Converts a time from type TIMS to type TIMN. | x | x | x |
| TSTMP_ADD_SECONDS | Adds seconds to a time stamp. | x | x | x |
| TSTMP_CURRENT_UTCTIMESTAMP | Current UTC time stamp. | x | x | x |
| TSTMP_IS_VALID | Shows whether the argument is a valid time stamp. | x | x | x |
| TSTMP_SECONDS_BETWEEN | Difference between two time stamps in seconds. | x | x | x |
| TSTMP_TO_DATS | Local date of a time stamp. | x | x | x |
| TSTMP_TO_DST | Local daylight saving time marker of a time stamp. | x | x | x |
| TSTMP_TO_TIMS | Local time of a time stamp. | x | x | x |
| TSTMPL_FROM_UTCL | Converts a time stamp from type UTCLONG to type TIMESTAMPL. | x | x | x |
| TSTMPL_TO_UTCL | Converts a time stamp from type TIMESTAMPL to type UTCLONG. | x | x | x |
| UTCL_ADD_SECONDS | Adds seconds to a UTC time stamp. | x | x | x |
| UTCL_CURRENT | Returns the current UTC time stamp within a SELECT-statement. | x | x | x |
| UTCL_SECONDS_BETWEEN | Difference between two UTC time stamps in seconds. | x | x | x |
| WEEKDAY | Shows the number of a weekday of a date. | x |
Descriptions of the possible operands and data types can be found in the corresponding documentation for ABAP CDS, DDIC-Based Views, ABAP CDS, View Entities and .
rdisp/max_wprun_time - Maximum work process run time PERFORM Short Reference
This documentation is copyright by SAP AG.
Length: 23326 Date: 20240427 Time: 044903 sap01-206 ( 179 ms )
