Sreemaha has Published 87 Answers

How many digits should be there in string or number so that it can be specified as a date value by MySQL?

Sreemaha

Sreemaha

Updated on 29-Jan-2020 06:43:57

While considering the year as 4-digit value, minimum of 8 digits in a string or number is required for MySQL to specify it as a date value. In this case, if we also want to store microseconds then the value can be up to a maximum of 20 digits.mysql> Select ... Read More

How to get the first day of the previous month in MySQL?

Sreemaha

Sreemaha

Updated on 29-Jan-2020 05:19:15

With the help of following MySQL query, we can get the first day of previous month −mysql> SELECT DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH, '%Y-%m-01') AS 'FIRST DAY OF PREVOIUS MONTH'; +-----------------------------+ | FIRST DAY OF PREVOIUS MONTH | +-----------------------------+ | 2017-09-01                  | ... Read More

How to call a JavaScript Function from Chrome Console?

Sreemaha

Sreemaha

Updated on 09-Jan-2020 06:30:27

To call a JavaScript function from the console, run the following code:Example<!DOCTYPE html> <html>    <body>       <script>          var display = {             displayOne: function(){ return "displayTwo" ;}          };          console.log(display.displayOne());   ... Read More

How to call a JavaScript function from an onmouseout event?

Sreemaha

Sreemaha

Updated on 08-Jan-2020 10:37:23

The onmouseout triggers when you move your mouse out from that element.ExampleYou can try to run the following example to learn how to call a JavaScript function from onmouseout eventLive Demo<html>    <head>       <script>          <!--             function over() ... Read More

How do JavaScript closures work?

Sreemaha

Sreemaha

Updated on 02-Jan-2020 09:41:22

In JavaScript, closure is the grouping of a function and where that function declared. In JavaScript, all functions work like closures. A closure is a function uses the scope in which it was declared when invoked. It is not the scope in which it was invoked.ExampleYou can try to run ... Read More

Displaying distinct values in a column filtered on other column in SAP BO report

Sreemaha

Sreemaha

Updated on 10-Dec-2019 09:05:26

There are multiple ways to do this. First is by creating a variable like this:Terms Count =Count([Terms Code]) in ([Sales #])You have to add this variable to your report. It will display 1 for all Sales # 1000 and 2 for all Sales # 1001. You can apply a filter ... Read More

Downloading SAP.NET connector to integrate .NET application with SAP system

Sreemaha

Sreemaha

Updated on 10-Dec-2019 08:00:40

Please note that you can use SAP.NET connector when your API’s are available on SAP system. If this is not correct, you need to get some ABAP programming to develop RFC functions.You can download SAP.NET connector from SAP Market place. To login to market place you need SAP Partner ID ... Read More

How to disable JavaScript in Opera?

Sreemaha

Sreemaha

Updated on 30-Sep-2019 08:25:42

To disable JavaScript in Opera, follow the below given steps:Open Opera browser and click on the left. Then click Settings:Now under Search Settings, search javascript.On searching, you will get the following options to disable javascript as shown below:

What is the difference between JavaScript and C++?

Sreemaha

Sreemaha

Updated on 30-Sep-2019 07:06:17

The following are the differences between JavaScript and C++.JavaScript is a lightweight, interpreted programming language. It is designed for creating network-centric applications. It is complementary to and integrated with Java. JavaScript is very easy to implement because it is integrated with HTML. It is open and cross-platform.C++ is a middle-level ... Read More

How to do case-sensitive string comparison in JavaScript?

Sreemaha

Sreemaha

Updated on 12-Sep-2019 08:26:42

As JavaScript is case sensitive, so case-sensitive comparison are simple string comparisons. This can be done without using any JavaScript method:<!DOCTYPE html> <html>    <body>       <h3>JavaScript Strings</h3>       <p id="test"></p>       <script>          var str1 = "amit";       ... Read More

Advertisements