We can add ‘half year interval’ in date ith the following ways −(A) By adding interval of 6 Monthsmysql> Select '2017-06-20' + INTERVAL 6 Month AS 'After Half Year Interval'; +--------------------------+ | After Half Year Interval | +--------------------------+ |  2017-12-20              | +--------------------------+ 1 row ... Read More

When we try to do such kind of operations with date values stored in the table then MySQL is assuming the date values as the number and perform the arithmetic.Suppose we have a table named ‘example’ having a date value in ‘orderdate’ column then following arithmetic operation will clarify the ... Read More

The default format for MySQL DATE data type is “YYYY-MM-DD” and in this format, there is no possibility to store the time value. Hence, we can say that we cannot use DATE data type along with time value.As we can see in the following example MySQL returns only date value ... Read More

A method in JavaScript is the action performed on objects. A JavaScript method has a function definition, which is stored as a property value. ExampleLet’s see an example to define a method in JavaScriptLive Demo                             ... Read More

JavaScript basics include an overview of JavaScript. JavaScript is a dynamic computer programming language. It is lightweight and most commonly used as a part of web pages, whose implementations allow a client-side script to interact with the user and make dynamic pages. It is an interpreted programming language with object-oriented ... Read More

JavaScript is a lightweight, interpreted programming language. It is designed for creating network-centric applications. It is complementary to and integrated with Java. It is very easy to implement because it is integrated with a HTML. It is open and cross-platform.We cannot treat JavaScript as a full-fledged programming language. It lacks ... Read More

You can make use of CL_ABAP_FILE_UTILITIES => CHECK_FOR_BOM to define file encoding type and use constantly of class CL_ABAP_CHAR_UTILITIES to process the files.ClassCL_ABAP_CHAR_UTILITIESShort DescriptionUtilities for Processing Characters

You can test the connection using T-code: SE38 using ADBC_TEST_CONNECTION. You could check details of exception as below:TRY. EXEC SQL. CONNECT TO 'ZUNIXDB_DBCON' ENDEXEC. EXEC SQL. OPEN dbcur FOR SELECT id FROM table ENDEXEC. CATCH cx_sy_native_sql_error INTO lr_cx_native_sql_error.Read More

To perform this without using Function module, you can use class- “cl_rebf_ddic_tabl”. Note that Class methods are almost similar to function modules. They are defined as code blocks to perform specific functionality.ExampleTry using below code: CALL METHOD cl_rebf_ddic_tabl=>exists EXPORTING    id_name = [table name]    id_tabclass = 'TRANSP' " For table ... Read More

JavaScript's interaction with HTML is handled through events that occur when the user or the browser manipulates a page.When the page loads, it is called an event. When the user clicks a button, that click to is an event. Other examples include events like pressing any key, closing a window, ... Read More