Understood. Example. Multi-Valued. SAP HANA SQL Reference Guide for SAP HANA Platform. SAP HANA SQL Reference Guide for SAP HANA Platform. by Johannes Klostermeier. ADD_WORKDAYS. Description. 0 SPS 12 ; This document. For example, the empty date can be represented as '', which behaves like an empty string. Microsoft SQL Server to SAP HANA Data Type Mapping; Modeling Guide for SAP Web IDE and SAP Business Application Studio. tzone INTO DATE calday . It give me 'DD/MM/YYYY' format, the right one is 'YYYY/MM/DD'. Don’t forget to subscribe and follow SAP HANA Cloud on YouTube to always stay up-to-date regarding the most recent innovations in SAP HANA Cloud. The column-oriented in-memory database design allows you to run advanced analytics alongside high-speed transactions –. In the SAP HANA database, each data type can be classified by its characteristics as follows: Classification of data types; Classification. 0 SPS 02 ; 2. SAP HANA SQL Reference Guide for SAP HANA Platform. In this case, a currency conversion is to be performed. The first step is to create the target table using HVR as part of the initial load from SAP into Snowflake. You may choose to manage your own preferences. Available Versions: 2. Hi Jeff, To find max date, use below query: SELECT MAX (Date Field) FROM TABLE and you will get the max date. 0 SPS 07. It also satisfies a IS NOT NULL predicate. The data and time format ( datetimeformat) specifies the way in which date values , time values and time stamp values are represented. 1. 0 SPS 03. I get this error: Unsupported date/time used in imported data Modify the data and import again. SAP BW/4HANA: An updated version of SAP BW that includes multiple new data warehousing features and runs on the SAP HANA database. This blog post will give an example of using SAP HANA Core data services (CDS) function as SUBSTRING, CAST and CONCAT for HANA view. 2017-11-20 which is represented as string "20171120") to a HANA date via sql script. Tools to detect potential. . More Information. DATE: 01. ) 201703301. If the input date is the last day of the input month, then the output. signum = '-' for subtract days. The following example increments the specified date value 2009-12-05 by 1 year, and returns the value 2010-12-05: SELECT ADD_YEARS (TO_DATE ('2009-12-05', 'YYYY-MM-DD'), 1) "add years" FROM DUMMY; Related Information So I now want to use this same query (achieving same results) in SAP HANA but there is no date trunc function and I also tried. SQL - SAP HANA - Use only first entry in. Use Snowflake’s powerful migration toolkit to speed up the process and make the transfer as. It enables the use of dynamic, time-dependent stock levels to cover material requirements considering a minimum safety. Display default format for timestamps in SAP HANA Studio. you have an import model; or BW Live model; or HANA LIVE model; you used a date dimension or non-date dimension to calculate the accumulated sum; In this case, you can use “add calculation” from your target measure column to achieve multiple types of. From this point, I can iterate over the dates until I find the desired week number. First of all extract October from the October 2012 string, for that you need to write function Left ("October 2012";Pos ("October 2012";" ")) and save it in a variable "ABC"--- this will give you October. In the blog I consider 2 scenarios: System versioning (SV): HANA registers timestamp ( defined by HANA server) of changing data in a HANA table. "DocDate" between '20200101' and '20200131'SAP HANA and Informix DATE data type are equivalent and store year, month, day values. 0 SPS 02 ; 2. [2] [3] Its primary function as the software running a database server is to store and retrieve data as requested by the applications. KEY = T2. We need to convert a datetime column ('01/01/2009 17:13:00') to a simple date ('01/01/2009 00:00:00'). Choose Recover Tenant Database. Provide a set of tools to identify, gather, analyze, and make available the most context-relevant data throughout your enterprise. Hi All, String is in following format: 2006-12-07 i. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. SAP HANA Modeling Guide. 0 SPS 04 ; 2. You can connect to SAP HANA data sources directly using DirectQuery. You may choose to manage your own preferences. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. YYYY stands for the year, MM for the month and DD for the day. . However, what I need is to add only a certain amount of milliseconds to a date, so for example if the current. 0 SPS 04 ; 2. 0: Release Information- This enables the maximum areas of the existing SAP ERP functions for SAP HANA to be able to utilize the in-memory technology and also enable better performing. 0 SPS 06 ; 2. SAP documents this in SAP notes ,) in HANA 2. 7. To create an OData service from an existing HANA table (or view), you define a service definition file with the suffix . py when the database if offline. 1. Interprets datearg (a date, without timezone) as utc and convert it to the timezone named by timezonearg (a string) Converts the local datetime datearg to the. 1. Which one to use depends on how you want to handle tie values. ADD_MONTHS. Example. XMLEXTRACT Function (Miscellaneous) XMLEXTRACTVALUE Function (Miscellaneous) XMLTABLE Function (String) YEAR Function (Datetime) YEARS_BETWEEN Function (Datetime) Aggregate Functions. It also satisfies a IS NOT NULL predicate. Im getting date for a field from source in dd/mm/yyyy format. TO_DATE Function (Data Type Conversion) Date Functions. The string must be a valid timestamp format code. Hi Pavneet, Please try this : SELECT DAYS_BETWEEN (TO_DATE (START_DATE), TO_DATE (END_DATE)) FROM DUMMY; or add this in your calculated column. 0 SPS 01 ; 2. 0 (or another format like Jan 11, 2010 1:30:00. SAP HANA SQL Reference Guide for SAP HANA Platform. However, this does not always fly. Protecting sensitive information is one of the most important priorities for you as an SAP HANA customer. On this page. This is the default value. We need to convert a datetime column ('01/01/2009 17:13:00') to a simple date ('01/01/2009 00:00:00'). Even though an empty date looks like a NULL or unknown value, it is not. 1990) Any suggestions would be appreciated. 32 – Customers With Missing Credit Data F. hana日期函数. SAP Suite on SAP HANA • SAP Simple Finance 1. A DAYDATE is computed by taking the Julian Day Number of the specified date and subtracting 1721423. If no value is provided the current. Large Objects. LOCALTOUTC (. data : v_days type i. This site uses cookies and related technologies,. format-style The style code to apply to the output value. The following example increments the date value 2009-12-05 by 30 days,. The parameter <date> must be implicitly or explicitly converted to one of the following SQL data types: The SQL data. The parameter <date> must be implicitly or explicitly converted to one of the following SQL data types: The SQL data. The following example returns the local and UTC time of the system: SELECT CURRENT_TIME "Current Time", CURRENT_UTCTIME "Coordinated Universal Time" FROM DUMMY; Current Time. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. From target table i have to fetch the amount and quantity information for the time between derived date and current date. It uses random-access memory (RAM) to help organize, analyze, and provide real-time information on big data. Both the WEEK and ISOWEEK functions return the week number for a specified date but the format of the result is quite different, and the two functions may handle the first week of the new year differently. I have tried using YYYY-MM-DD and YYYYMMDD format. Analyze Stock in Date Range. If format-style is specified, the database server may use it as a hint on how to parse the string. I know from HANA's SQL and System Views Reference that there are currently 5 functions available to add an amount of time to a date: ADD_YEARS. SAP HANA, Database, SAP Software, Database Migration, HANA Programming, SAP BW/4HANA, Application Development for SAP HANA. I cant think of any function combinations that would allow me to pull this information. Refer to the Introduction and blog post indexes here: As you saw in the previous blog post, in the Basic CDS view the data has been read with a simple ‘Select’ statement. I need some help on below issue in HANA modeler-I have date in 2015-10-09 stored in table. SELECT TO_DECIMAL (1234. Introduction to ABAP development tools (also known as ABAP in Eclipse) Taking ABAP to SAP HANA. databaseName <name> Specifies the name of the database to connect to. The range is between 0001-01-01 and 9999-12-31. SAP HANA, Database, SAP Software, Database Migration, HANA Programming, SAP BW/4HANA, Application Development for SAP HANA. Suppose you have business requirements based on some date column you need to do some manipulation or calculation based on Current Quarter Beginning Date, Last Quarter. SAP HANA SQL Reference Guide for SAP HANA Platform. SAP HANA SQL Reference Guide for SAP HANA Platform. 0 (or another format like Jan 11, 2010 1:30:00. Solutions for each case: If DocDate type is NVARCHAR 8 with format YYYYMMDD: select * from OPDN A where A. . 0 SPS 06 ; 2. 0 SPS 07 release plans to continue to lower total-cost-of-ownership (TCO) as well as provide enhanced. 0 SPS 07. Hana Studio-Calculation Views-Calculated Column Date field to Year. In SAP HANA I can use filters as SQL or Column Store expression within a modelling view (e. The system checks the posting date and the related posting period twice: When you post an FI-CA document, the system checks whether the posting period belonging to the posting date is still open or whether the posting date is in the future (comparison date is the CPU date). This function calculates the number of date parts between two specified dates. SELECT EXTRACT (DAY FROM TO_DATE (START_TIME, 'YYYY-MM-DD')) "extract" as day, bus_id, sum (distance_two_points) as distance FROM public. 20,130,905,200,845 +02:00. Ideally, there is a way to only extract changed records, for example, using a change date column. 0 SPS 07. 3. SAP HANA SQL Reference Guide for SAP HANA Platform. An empty date (0000-00-00) is a special value in SAP HANA. Best regards Roland. We do not recommend connecting via an OData service connection due to timeout/dataset limits. 0), Customer Relationship Management (CRM 7. Multi-Valued. The portions that the function can return are the year, the month, the day of the year, the day of the month, the day of the week, the hour, the minute, or the second. CREATE ROW TABLE T0 ( C1 INT ) INSERT INTO T0 VALUES ( 21 ) INSERT INTO T0 VALUES ( 22 ) INSERT INTO T0 VALUES ( 23 ) INSERT INTO T1 VALUES ( 2, ARRAY ( SELECT C1 FROM T0 ) ) Insert a NULL value into an ARRAY. Part#3. Search Scopes: All SAP products; This product;. As a developer, one way to retrieve only the data your customers need is by applying a filter to your calculation views in SAP HANA Studio. 13 43 19,463. which function module should i used to convert it? Regards, Nilima. An example output from that table-field is 202135. 2. SELECT TO_VARCHAR (TO_DATE ("CREATEYEAR",'YYYYMMDD'),'DD-MM-YYYY', FROM DUMMY not working. In this blog post, I will bring into discussion how SAP S/4HANA is addressing and developing the solutions for direct and indirect tax. Array Functions. To look up the version of your system, go to: More > System > Status > SAP System Data > Installed Product Versions. IF between time in SAP HANA. The value 3652062 is the NULL value. Use the following statements to test the behavior of the empty date value: The following example increments the date value 2009-12-05 by 30 days, and returns the value 2010-01-04: SELECT ADD_DAYS (TO_DATE ('2009-12-05', 'YYYY-MM-DD'), 30) "add days" FROM DUMMY; Related Information How does one handle exceptions in date casting in SAP's HANA? 0 HANA SQL:Import Excel Field formatted as date into Dataset or convert excel date values (eg. If you encounter an issue with one code format producing unexpected results, use the alternate code instead. Current date in SAP HANA and difference between dates. 0 SPS 06 ; 2. Sorted by: 4. hana Share Improve this question Follow edited Feb 12 at 14:56 Sandra Rossi 12k 5 22 49 asked Feb 7, 2017 at 10:19 user7477092 Add a comment 5 Answers Sorted. Let. 0 SPS 07 ; 2. 0 SPS 06 ;. Without format, you can display date in the format of "2019-05-22 14:32:19. (In excel, enter the date in excel, right click on date and format cells, select Number and keep the Decimal Places to "0") 11/01/2018 -> 43405. Upgrade is started now, will take around 2-3mins to complete. SAP HANA TIME data type can be used to store Informix DATETIME HOUR TO SECOND, DATETIME HOUR TO MINUTE values, and any other DATETIME type with qualifiers HOUR, MINUTE, SECOND, except FRACTION(n). While developers to date have been able to freely explore SAP HANA Cloud with the Trial version, the new free tier model offers some additional benefits including: Availability on many more landscapes – This includes several AWS and Azure landscapes in regions spanning the Americas, Europe, and Asia-Pacific. I am not sure if you can use CURRENT_DATE in the calculated attributes. My task is to convert a ABAP style date (i. 0 SPS 01 ;Date and time functions perform operations on date and time data types or return date or time information. 0 SPS 06 ; 2. This site uses cookies and related technologies,. While the function is called TO_VARCHAR, in SAP HANA, VARCHAR is an alias for the NVARCHAR data type. In this blog post, I have the pleasure to walk you through the key aspects that bring intelligence to our digital core along with some of the highlights of the release. Improve this answer. 2006 date format. 0 SPS03 and 2905198 – What’s HANA Behavior when Calculation Days Between?. 0 SPS 07 ; 2. How can I have this just pass the current year? I've seen a few different potential solutions but most of them are in HANA Studio or involve dynamic SQL generation. Sep 26, 2016 at 06:54 AM. Available Versions: 2. Use this parameter when converting strings to date or time data types, and vice versa. A string indicating the format of the generated string. Computes the specified date, plus or minus the specified number of days. The first part can be done in HANA like this: to_date ( "<year_column>" || "<month_column>", 'YYYYMM') as newDate. 0 SPS 04. Even if the format is not listed in the current documentation, you can use a statement like. Available Versions: 2. 12. The default format for the TIME data type is HH24:MI:SS. It is possible. The above query will give us a calculated column with the date 30 days from the current one. For example, a comparison of BIGINT and VARCHAR is. Date and time functions perform operations on date and time data types or return date or time information. I want to convert them to date format. signum = '+'. For a date/time type, include an optional format string to specify the format of the output string. 6. I am excited to share that the 2022 release of SAP S/4HANA Cloud, private edition, and SAP S/4HANA is here – the most intelligent and comprehensive ERP to date. HANA studio is built on top of eclipse, and for some reason, the date format is fixed that way. SAP EHP 6 for SAP ERP 6. CONVERT TIME STAMP my_TSTMP TIME ZONE. The DATE data type consists of year, month, and day information to represent a date value. The phrase can be traced as far back as Philip II of Macedonia ( divide et impera. tzone INTO DATE calday . More Information. 0 SPS 05 ; 2. but tzone is expected in the formate of UTC-1 or UTC+2 as such. SELECT TO_DATS ('2010-01-12') "abap date" FROM DUMMY; I have a time stamp field in a table that shows the number of seconds since 1. In a query transform, I tried changing the right column type from 'datetime' to 'date' , but with no success. The usage of local timestamps is discouraged; use UTC times instead. 1. To compute the date so that the output date is set to the last day of the month when the input date is the last day of the month, use the ADD_MONTHS_LAST function. SAP HANA Service for SAP BTP in AWS and Google Cloud Regions; SAP HANA SQL Reference Guide for SAP HANA Platform; SQL Reference; SQL Functions; Alphabetical List Of Functions; CURRENT_DATE Function (Datetime) An empty date (0000-00-00) is a special value in SAP HANA. The column-oriented in-memory database design allows you to run advanced analytics alongside high-speed transactions –. 0 SPS 07 release plans to continue to lower total-cost-of-ownership (TCO) as well as. 3. 0: version for SAP HANA- this was the first version of SAP Business Suite on HANA. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. The DATE data type consists of year, month, and day information to represent a date value. 0 SPS 07. SAP HANA convert YYYYWW to MM/DD/YYYY. 0 SPS 06 introduces many new innovations for administrators, operators and security experts of SAP HANA databases using the SAP HANA cockpit and SAP HANA database explorer management tools. As well as usage of syntax such CONVERT. Description: Converts a specified date from a field to a text string. YYYY-MM-DD. SAP HANA SQL Reference Guide for SAP HANA Platform. 1、current_date--返回当前本地系统日期。. I am writing this Blog Post for beginners, so that they can find many functions at one place. 000. Could you please let me know how to convert the date into number in SAP HANA ? For example, the today's date 11/02/2018 (November 02, 2018) is converted to 43406. Date and time functions are scalar functions that perform an operation on a date and time input value and returns either a string, numeric, or date and time value. . SAP HANA supports 7 categories of SQL data types and it depends on the type of data you have to store in a column. Vivek Singh Bhoj. Example The following example converts the string 2010-01-12 to a DATE value with the format YYYY-MM-DD , and returns the value 2010-01-12 . Insert values into an array value construction by query. CREATE ROW TABLE T2 (KEY INT PRIMARY KEY, VAR INT); INSERT INTO T2 VALUES (1, 2); INSERT INTO T2 VALUES (3, 6); Update the values of table T by joining the target table T with table T2. 0 SPS 05 ; 2. In both cases the system allows you. The following example converts the string 2010-01-12 to a DATE value with the format YYYY-MM-DD, and returns the value 2010-01-12 (or another format like Jan 12, 2010,. 21. SAP HANA SQL how to convert Date and Time to timestamp. Fortunately the dates are given in single quotes in a SQL query, hence this should not stop us to go ahead. hana日期函数. 0. It then converts it again to an NVARCHAR type and returns the value 2009/12/31. 0 SPS 06, and we’re looking forward to seeing how our customers continue to use SAP HANA to gain. 0 SPS 07. 0 SPS 06 ; 2. Date and time functions are scalar functions that perform an operation on a date and time input value and returns either a string, numeric, or date and time value. I am using query transform and in the where clause , there is a comparison between timestamp column (TRX_DATE_TIME) and datetime column (FROM_DATE,TO_DATE). Nilima. MM. 0. Note, that the target time zone name may be something like "GMT+1" but this is really just a name and not a calculation instruction. 0 SPS 06 ; I've just looked in this forum, youtube and another websites the right formula to convert a Column with the dates as NVARCHAR string YYYYMMDD to DD/MM/YYYY with no sucess. YYYY represents the year, MM represents the month, and DD represents the day. datatable where start_time >= '2015-09-05 00:00:00' and start_time <= '2015-09-05. “Start Date” & “End Date” dragged into “Query Filters” (see below) 2. <format>. Available Versions: 2. For example, the empty date can be represented as '', which behaves like an empty string. The function takes a string as the portion argument, and a seconddate or bigdatetime for the datevalue argument. Calculation View). Date Time. Data Type Conversion Functions. CREATE ROW TABLE T2 (KEY INT PRIMARY KEY, VAR INT); INSERT INTO T2 VALUES (1, 2); INSERT INTO T2 VALUES (3, 6); Update the values of table T by joining the target table T with table T2. Returns the ISO year and week numbers of the date specified by <date> . ADD_SECONDS The following example returns the value 5, the month for the date specified: SELECT MONTH ('2011-05-30') "month" FROM DUMMY; Converts a specified date string to a SECONDDATE data type. SAP HANA SQL Reference Guide for SAP HANA Platform. "CreateTS" and "UpdateTS" store just the time in format hhmmss as int. 2. The standard format of this data type is YYYY-MM-DD. To follow the steps in this blog you need to be familiar with the earlier blog SAP AI Core – Scheduling. Use the following statements to test the behavior of the empty date value:In SAP HANA database, there are also four specific types (SAP Library "Datetime Data Types"): DATE, TIME, SECONDDATE, TIMESTAMP. 0 • SAP Simple Finance, on-premise edition 1503 • SAP S/4HANA Finance 1605 Note. Date and time functions are scalar functions that perform an operation on a date and time input value and returns either a string, numeric, or date and time value. Available Versions: QRC 3/2023 ; QRC 2/2023 ; QRC 1/2023 ; QRC 4/2022 * QRC 3/2022 * QRC 2/2022 *. 4, the source and target databases are Oracle 10g. SAP HANA, Database, SAP Software, Database Migration, HANA Programming, SAP BW/4HANA, Application Development for SAP HANA. This site uses cookies and related technologies, as described in our privacy statement , for purposes that may include site operation, analytics, enhanced user experience, or. TRX_DATE_TIME>=FROM_DATE and. 0 SPS 12 ; This document. 5 AS INTEGER) "cast" FROM DUMMY; Computes the specified date plus the specified number of months. SAP HANA SQL Reference Guide for SAP HANA Platform. The following example converts the value 2009-12-31 to a date value with the format YYYY/MM/DD. Coordinated Universal Time. The following example converts the value 10 to the INT value 10: SELECT TO_INT ('10') "to int" FROM DUMMY; The following example converts the value 10. The goal is to calculate the sum of amount for all records from beginning of the current year up to a certain date that can be entered at runtime. Converting the DATE 2013-07-03 to a TIMESTAMP returns 2013-07-03. 0 SPS 05 ; 2. 440776". Datetime to Date conversion. create a new calculation d_date. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. The date is stored as sql type "'nvarchar" 10 string. In such a case SAP HANA will try to automatically convert the value into a date data type and fails if the format is not one of the documented standard formats. SAP HANA SQL Reference Guide for SAP HANA Platform. Don’t forget to subscribe and follow SAP HANA Cloud on YouTube to always stay up-to-date regarding the most recent innovations in SAP HANA. data v_date type sy-datum. Numeric. You may choose to manage your own preferences. Tax, both direct and indirect, is also an area where legal regulations and the mandatory changes have a high impact and where technology would need to quickly adapt in order to continue providing viable solutions. The first quarter starts in the month specified by <start_month>. 2. 2. SAP documents this in SAP notes ,) in HANA 2. F. 000 for time. Tools to detect potential functional and performance issues when migrating to SAP HANA: code inspector and ABAP test cockpit, ABAP trace and ABAP profiler, SQL trace. The example below illustrates an equivalent way of writing the previous example using the SERIES TABLE syntax and a series table named MySeries: CREATE COLUMN TABLE MySeries (id INTEGER, pos INTEGER) SERIES (SERIES KEY (id) EQUIDISTANT INCREMENT BY 1 MINVALUE 1 MAXVALUE 5 PERIOD FOR SERIES (pos)); SELECT. In order to understand the working of HANA and its delta merge concepts, it is important. data : v_days type i. Ravindra Channe. 2. distribution: OFF, CONNECTION, STATEMENT, ALL. XMLEXTRACT Function (Miscellaneous) XMLEXTRACTVALUE Function (Miscellaneous) XMLTABLE Function (String) YEAR Function (Datetime) YEARS_BETWEEN Function (Datetime) Aggregate Functions. "UpdateDate" and "CreateDate" are stored as Date in SAP HANA, keeping year, month, day and 00:00:00. So there is always a killer for using PowerBI with a SAP BW HANA calculation view, which would be great as this is such a great tool for handling data. The SAP HANA 2. SAP HANA Cloud, SAP. The recommended approach is to use the acquired data connection to SAP HANA according to steps described per our official users guide: Import Data Connection to SAP HANA. So, we are only 2 days away from the. Read the blog on administration, monitoring and security. 0 SPS 12 ;The impact of 2027 on SAP customers. 764. While the function is called TO_VARCHAR, in SAP HANA, VARCHAR is an alias for the NVARCHAR data type. 0 SPS 05 ; 2. Solutions for each case: If DocDate type is NVARCHAR 8 with format YYYYMMDD: select * from OPDN A where A. Our 3 to RUN initiative empowers you to schedule our chosen classroom training course or virtual SAP Live Class on a date that suits you. User has the option to see what data was in the HANA table at any defined timestamp in the past. An empty date (0000-00-00) is a special value in SAP HANA. SELECT TO_DATE ('20100112', 'YYYYMMDD') "to date" FROM DUMMY; SELECT TO_VARCHAR (TO_DATE ('20120215', 'YYYYMMDD'), 'YYYY-MM-DD') "to date" FROM DUMMY; As a_horse_with_no_name mentioned, you can use the SAP HANA SQL and System Views Reference for help on writing queries. Understood. The goal is to calculate. 0 SPS 01 ;. because both functions return date values. In SQL statements, it determines the format in which the date, time, and timestamp values can be represented in these SQL statements, and the way in which results are displayed. 1. 9999999. 0 SPS 07 ; 2. For any given year I know the week 1 start date is the first of January. Use SAP HANA streaming analytics Time Format codes instead of strftime() codes. Tax, both direct and indirect, is also an area where legal regulations and the mandatory changes have a high impact and where technology would need to quickly adapt in order to continue providing viable solutions. 0. So after you read this tiny article you should be able to select on DEC15 dates in a Hana DB. Step 1. Calculate the number of whole weeks, multiply by 5. However, the actual content of the data blocks is not analyzed. 20,130,927,183,711 -04:00. The infrastructure stamps that run the SAP HANA on Azure (Large Instances) units are connected to the Azure network services backbones. Example The following example increments the date value 2009-12-05 by 30 days, and returns the value 2010-01-04 : Converts a date string into a DATE data type. Regarding the documentation on this, you can check the HELP in HANA Studio and search for "Functions used in Expressions" and check the function. Divide and Conquer. 0. SAP HANA (High-performance ANalytic Appliance) is a multi-model database that stores data in its memory instead of keeping it on a disk.