Sravani S has Published 79 Articles

How MySQL reacts when we specify a CHARACTER SET binary attribute for a character string data type?

Sravani S

Sravani S

Updated on 20-Jun-2020 07:36:30

209 Views

On specifying a CHARACTER SET binary attribute for a character string data type, MySQL creates that column as its subsequent binary string type. The conversions for CHAR, VARCHAR and BLOB data types take place as follows −CHAR would become BINARYVARCHAR would become VARBINARYTEXT would become BLOBThe above kind of conversion ... Read More

In MySQL, how can we use FROM_UNIXTIME() function with format string?

Sravani S

Sravani S

Updated on 20-Jun-2020 06:41:59

201 Views

Suppose if we want the output of FROM_UNIXIME() function in a particular format then we can use date format string or time format string or both in it. Following is the example of using the format string in FROM_UNIXTIME() function −mysql> Select FROM_UNIXTIME(1555033470 '%Y %M %D')AS 'Formatted Output'; +------------------+ | ... Read More

In MySQL, how can we find which quarter is going on from current date or particular given date?

Sravani S

Sravani S

Updated on 20-Jun-2020 06:13:24

150 Views

We can do it by providing unit value ‘quarter’ to EXTARCT() function. Examples are as follows −mysql> Select EXTRACT(Quarter from '2017-07-29'); +------------------------------------+ | EXTRACT(Quarter from '2017-07-29') | +------------------------------------+ |                                  3 | +------------------------------------+ 1 row ... Read More

How to get the current time in millisecond using JavaScript?

Sravani S

Sravani S

Updated on 19-Jun-2020 08:49:02

2K+ Views

To get the current time in a millisecond, use the date getMilliseconds() method. JavaScript date getMilliseconds() method returns the milliseconds in the specified date according to local time. The value returned by getMilliseconds() is a number between 0 and 999.Example You can try to run the following code to get the ... Read More

How to get the current year in JavaScript?

Sravani S

Sravani S

Updated on 18-Jun-2020 09:16:11

3K+ Views

To get the current year, use the getFullYear() JavaScript method. JavaScript date getFullYear() method returns the year of the specified date according to local time. The value returned by getFullYear() is an absolute number. For dates between the years 1000 and 9999, getFullYear() returns a four-digit number, for example, 2008.ExampleYou ... Read More

Can we define an interface inside a Java class?

Sravani S

Sravani S

Updated on 16-Jun-2020 11:20:18

7K+ Views

Yes, you can define an interface inside a class and it is known as a nested interface. You can’t access a nested interface directly; you need to access (implement) the nested interface using the inner class or by using the name of the class holding this nested interface.ExampleLive Demopublic class Sample ... Read More

Does Java support default parameter values for a method?

Sravani S

Sravani S

Updated on 16-Jun-2020 11:12:26

2K+ Views

Java does not support the concept of default parameter however, you can achieve this usingMethod overloadingUsing method overloading if you define method with no arguments along with parametrized methods. Then you can call a method with zero arguments.Variable argumentsIn Java methods parameters accept arguments with three dots. These are known ... Read More

Learning about SAP ABAP CDS views

Sravani S

Sravani S

Updated on 12-Jun-2020 12:38:57

3K+ Views

First thing, whether it is CDS or ABAP or anything pertaining to SAP, you can always find free courses on  https://open.sap.com/  referred as Open SAP. Besides this, there are lot of free help as well just Google it and the result list is huge.There are various self-learning tutorials site that ... Read More

How to search the alternate text of an image-map area in JavaScript?

Sravani S

Sravani S

Updated on 23-May-2020 11:22:37

164 Views

To search the alternate (alt) text of an image-map area in JavaScript, use the alt property. You can try to run the following code to get the alternate text.Example                                                      var x = document.getElementById("myarea").alt;          document.write("Alternate Text: "+x);          

What is the role of altKey Mouse Event in JavaScript?

Sravani S

Sravani S

Updated on 23-May-2020 09:13:53

218 Views

The altkey mouse event property is used to show whether SHIFT key is pressed or not when mouse button is clicked.ExampleYou can try to run the following code to learn how to implement altKey Mouse event in JavaScript.           Press and hold ALT key and ... Read More

Advertisements