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
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to display only hour and minutes in MySQL?
To display only hour and minutes, use DATE_FORMAT() and set format specifiers as in the below syntax −select date_format(yourColumnName, '%H:%i') as anyAliasName from yourTableName;Let us first create a table −mysql> create table DemoTable1527 -> ( -> ArrivalDatetime datetime -> ); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1527 values('2019-01-10 12:34:45'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable1527 values('2018-12-12 11:00:34'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1527 values('2019-03-21 04:55:56'); Query OK, 1 row affected (0.18 sec)Display all records from ...
Read MoreOrder by last 3 months first, then alphabetically in MySQL?
Let us first create a table −mysql> create table DemoTable1526 -> ( -> CustomerName varchar(20), -> PurchaseDate date -> ); Query OK, 0 rows affected (0.67 sec)Insert some records in the table using insert command. Here, we have inserted 2019 dates −mysql> insert into DemoTable1526 values('Adam', '2019-06-01'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1526 values('Sam', '2019-04-26'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1526 values('Chris', '2019-05-24'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable1526 values('David', '2019-10-10'); Query OK, 1 row affected (0.23 sec) mysql> insert into ...
Read MoreWhat is the future of Selenium Automation testing, as a career option?
We are now living in a world of Cloud and Digital business. Application Development of almost all the platform is in boom. For providing utmost customer satisfaction, the application has to be seamless and bug-free.We have been living in the age of manual testing since very long. We have new requirements pitching in every now-and-then from the clients where there is either enhancement in the application or any modification. For testing these new requirements, we need to run the older test cases repeatedly to test if it is not affected by the new change. And we end up testing the ...
Read MoreCan I learn Selenium without knowing Java?
This Question comes to many professionals who are not actually into core technical and want to pursue their career in Selenium Automation. The term coding makes the non-programmers a bit scare to even start off with something like automation. There is a perception that a non-programmer cannot excel in Automation, but it is only in head. Many deserving and capable manual testers shy away from Selenium just thinking that it require some special skills.There are various many languages in which Selenium Scripts are designed such as Python, Ruby, C#, JavaScript and Java is one such of them. Knowing the popularity ...
Read MoreSelect date from MySQL and format to text?
To select date and format, use SELECT DATE_FORMAT(). Following is the syntax −Syntaxselect date_format(yourColumnName, '%e %b %y') from yourTableName;Let us first create a table −mysql> create table DemoTable -> ( -> DueDate date -> ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-01-11'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values('2019-12-21'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('2019-09-15'); Query OK, 1 row affected (0.07 sec)Display all records from the table using select statement −mysql> select *from ...
Read MoreGroup MySQL rows in an array by column value?
To group rows in an array, use GROUP_CONCAT() along with the ORDER BY clause. Let us first create a table −mysql> create table DemoTable -> ( -> Id int, -> FirstName varchar(20) -> ); Query OK, 0 rows affected (0.78 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(101, 'John'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(102, 'Bob'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values(101, 'David'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values(101, 'Adam'); Query OK, ...
Read MoreDifference between class alv and function alv in SAP ABAP?
Class alv and Function alv are different in terms of features. Below is the difference:Class alv are secured as compared to function alv.While using class alv, it improves the performance.With use of function alv, you can create screens using function module however you need to call separate programs to generate screen.Class alv provides Object Oriented functionality and hence they are easily reusable.You can execute function modules asynchronously and can also be called by other systems remotely.Below is an example of class ALV:DATA: lcl_alv TYPE REF TO cl_gui_alv_grid, t_gly TYPE STANDARD TABLE OF Travels . SELECT * FROM ...
Read MoreHow to connect to an SAP module?
You can create RFC function module and then call this function module from outside. You can create RFC using T-Code SE37You can use the following link to know more about using RFC function module:https://archive.sap.com/discussions/thread/333645This tells about how you can create an FM in SE37 in Target system enabling Remote-Function Enabled and using attributes of FM.To create an RFC connection, you need to use T-Code: SM59 mentioning Username and Password.Another link that you can refer which tells about creating RFC and Remote-enabled FM and call from another SAP system using ABAP Program:https://wiki.scn.sap.com/wiki/display/Snippets/Creating+RFC+and+Remote-enabled+FM+and+call+from+another+SAP+system+using+ABAP+Program
Read MoreDifferentiate between Transaction code SE01, SE09, and SE10 in SAP ECC system?
In early sap version, SE09 and SE10 perform different functions as below:SE09 was widely used in workbench/development of transports.SE10 was widely used in customizing transports.In newer version now, both the Transactions SE09 and SE10 perform the same function as shown in below snapshot.In addition, SE01 is an extension combining SE09 and SE10 functions and adding lot other functions as shown in below snapshot:
Read MoreHow to Fetch source code of the transaction note in SAP R/3?
If you ever need to fetch the mapped program with a transaction, you need to call the transaction SE93. It will fetch you the program and variant of the selection screen.Now, if you need source code then you can use the transaction SE38 or SE80. If you also require Dynpro which is mapped against the program then use SE80.
Read More