Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by seetha
Page 5 of 6
What are the different ways in MySQL to add ‘half year interval’ in date?
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 in set (0.00 sec)(B) By adding interval of 2 quartersmysql> Select '2017-06-20' + INTERVAL 2 Quarter AS 'After Half Year Interval'; +--------------------------+ | After Half Year Interval | +--------------------------+ | 2017-12-20 | +--------------------------+ 1 row in set (0.00 sec)Above query will add half year interval in date with the help of Quarter keyword.
Read MoreHow will addition, subtraction, multiplication and division operator work with date values stored in MySQL table?
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 above −mysql> select * from example; +------------+ | orderdate | +------------+ | 2017-05-25 | +------------+ 1 row in set (0.00 sec) mysql> select orderdate+10 from example; +--------------+ | orderdate+10 | +--------------+ | 20170535 | +--------------+ 1 row in set (0.00 sec) mysql> select orderdate*10 from example; ...
Read MoreWhy we cannot use MySQL DATE data type along with time value?
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 even on using time along with the date.mysql> select DATE("2017-09-25 09:34:21"); +-----------------------------------+ | DATE("2017-09-25 09:34:21") | +-----------------------------------+ | 2017-09-25 | +-----------------------------------+ 1 row in set (0.04 sec)However, in DATETIME and TIMESTAMP date data types we can use the time to date.
Read MoreHow to detect encoding and mixed line endings (Windows and Unix) in SAP?
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
Read MoreUnable to access DBCONN after upgrading to EHP7 in SAP system
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 MoreChecking table existence using Class and it’s method in SE11 without using FM in ABAP
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 * if_noview = ABAP_FALSE receiving rf_exists = yes . This will return “X” if the table exists in Transaction SE11.CALL METHOD CL_REBF_DDIC_TABL=>methodname EXPORTING/IMPORTING GET_TEXTTAB - Supplies the Corresponding Text Table GET_COMPLETE - Supplies All Technical Information GET_DETAIL_X - Supplies Extended Header Data GET_FIELD_LIST - ...
Read MoreWhat happens to MySQL temporary tables if MySQL session is ended?
Temporary table would be deleted if MySQL session terminates. After login again, on issuing the SELECT command we will find no data available in the database. Even our temporary table will not exist.
Read MoreUse IFrame and read cookie in ABAP
I think it is possible and can be simply achieved. You can do the following:Firstly, create a business server pages application on the server. Make sure the application contains a frameset and two IFrames as a part of the frameset.Then you need to split up the implementation between these two IFrames. First IFrame will contain the third party component and second component will contain the view and JS part of the application that we just created. Make sure the second frame does not have any height as it should be invisible to the user.Then you can write client-side code in ...
Read MoreWhat is meant by Java being ‘write once run anywhere’ language?
Unlike many other programming languages including C and C++, when Java is compiled, it is not compiled into platform specific machine, rather into platform independent byte code. This byte code is distributed over the web and interpreted by the Virtual Machine (JVM) on whichever platform it is being run on. Thus when you write a piece of Java code in a particular platform and generated an executable code .class file. You can execute/run this class file on any system the only condition is that the target system should have JVM (JRE) installed in it. In Short, If you have a ...
Read MoreWhat does import Java.util.* in Java do?
Java util package contains collection framework, collection classes, classes related to date and time, event model, internationalization, and miscellaneous utility classes. On importing this package, you can access all these classes and methods.Following table lists out the classes in the collection package.InterfacesDescriptionClassesCollectionCollection Interface represents a group of objects. It is a root interface of collection framework.Abstract CollectionSetIt is a dynamic group of unique elements. It does not store duplicate element.HashSetLinkedHashSetListThey are similar to sets with the only difference that they allow duplicate values in them.StackvectorArrayListLinkedListQueueIt is an arrangement of the type First-In-First-Out (FIFO).First element put in the queue is the ...
Read More