Search results
17 maj 2006 · This will give the difference in seconds. You can convert it to years or days as per your requirement. data : dt1 like CCUPEAKA-TIMESTAMP, dt2 like CCUPEAKA-TIMESTAMP, diff type i, days type i, years type i. dt1 = '20050101111111'. dt2 = '20040101112222'.
You can enter airports, cities, states, countries, or zip codes to find the flying time between any two points. The database uses the great circle distance and the average airspeed of a commercial airliner to figure out how long a typical flight would take.
The following example returns the value 31 for days between the two dates specified: SELECT DAYS_BETWEEN (TO_DATE ('2009-12-05', 'YYYY-MM-DD'), TO_DATE('2010-01-05', 'YYYY-MM-DD')) "days between" FROM DUMMY;
In ABAP, you can perform direct date calculations such as finding the difference between two dates or adding and subtracting a number of days from a given date. To perform the calculation, ABAP converts the dates into an integer (the number of days since 01.01.0001) and adds or subtracts the relevant values.
The function DATS_DAYS_BETWEEN calculates the difference between two specified dates, date1 and date2, in days. The actual parameters must have the predefined data type DATS and should contain a valid date in the format YYYYMMDD.
13 paź 2012 · Use the function module " HR_HK_DIFF_BT_2_DATE". Here is the implementation: CALL FUNCTION 'HR_HK_DIFF_BT_2_DATES' EXPORTING date1 = sy-datum. date2 = date2 output_format = '02' IMPORTING * YEARS = * MONTHS =
Function to get Transport request Logs. Function to get total service period of a employee. Functional location Bulk creation. Gateway Errors for CCMS Agent. Generating diagnostic dump of the HANA database. Get Changed Value In ALV Grid Dynamically. get the name of the month , date and year.
