Samual Sam has Published 2310 Articles

How do I cast a type to a BigInt in MySQL?

Samual Sam

Samual Sam

Updated on 30-Jul-2019 22:30:25

6K+ Views

You need to use the CAST operator along with CONV() function. The CONV() function can be used to convert one base number system to another base system.For Example, The 16 is one base system and 10 is another base system. The 16 base system is hexadecimal and 10 is a ... Read More

Provider values() method in Java

Samual Sam

Samual Sam

Updated on 30-Jul-2019 22:30:25

144 Views

The property values in the Provider can be viewed with an unmodifiable Collection view that is obtained using the method values() in the class java.security.Provider. This method requires no parameters and it returns an unmodifiable Collection view of the property values.A program that demonstrates this is given as follows −Example Live ... Read More

Create Unit Tuple from Array in Java

Samual Sam

Samual Sam

Updated on 30-Jul-2019 22:30:25

155 Views

To create Unit Tuple from array, use the fromArray() method.Let us first see what we need to work with JavaTuples. To work with Unit class in JavaTuples, you need to import the following package −import org.javatuples.Unit;Note − Steps to download and run JavaTuples program. If you are using Eclipse IDE ... Read More

ShortBuffer compact() method in Java

Samual Sam

Samual Sam

Updated on 30-Jul-2019 22:30:25

113 Views

The buffer can be compacted using the compact() method in the class java.nio.ShortBuffer. This method does not require a parameter and it returns the new compacted ShortBuffer with the same content as the original buffer. If the buffer is read-only, then the ReadOnlyBufferException is thrown.A program that demonstrates this is ... Read More

LocalDateTime getMonth() method in Java

Samual Sam

Samual Sam

Updated on 30-Jul-2019 22:30:25

248 Views

The month name for a particular LocalDateTime can be obtained using the getMonth() method in the LocalDateTime class in Java. This method requires no parameters and it returns the month name in the year.A program that demonstrates this is given as follows −Example Live Demoimport java.time.*; public class Demo {   ... Read More

Get a value from Unit Tuple class in Java

Samual Sam

Samual Sam

Updated on 30-Jul-2019 22:30:25

201 Views

Use the getValueX() method to get a value from Unit Tuple class in Java at a particular index. For example, getValue0().Let us first see what we need to work with JavaTuples. To work with the Unit class in JavaTuples, you need to import the following package −import org.javatuples.Unit;Note − Steps ... Read More

Sort certain values to the top in MySQL?

Samual Sam

Samual Sam

Updated on 30-Jul-2019 22:30:25

256 Views

You need to use ORDER BY clause to sort. The syntax is as follows −SELECT *FROM yourTableName ORDER BY yourColumnName='yourValue' DESC, yourIdColumnName;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table SortCertainValues    -> (    -> Id ... Read More

Clock tickMinutes() method in Java

Samual Sam

Samual Sam

Updated on 30-Jul-2019 22:30:25

211 Views

The current ticking value in minutes can be obtained using the method tickMinutes() in the Clock Class in Java. This method requires a single parameter i.e. the time zone and it returns the current ticking value in minutes.A program that demonstrates this is given as follows −Example Live Demoimport java.time.*; public ... Read More

LocalDateTime getMinute() method in Java

Samual Sam

Samual Sam

Updated on 30-Jul-2019 22:30:25

64 Views

The minute of the hour for a particular LocalDateTime can be obtained using the getMinute() method in the LocalDateTime class in Java. This method requires no parameters and it returns the minute of the hour in the range of 0 to 59.A program that demonstrates this is given as follows ... Read More

ShortBuffer arrayOffset() method in Java

Samual Sam

Samual Sam

Updated on 30-Jul-2019 22:30:25

120 Views

The offset of the first element of the buffer inside the buffer array is obtained using the method arrayOffset() in the class java.nio.ShortBuffer. If the buffer backed by the array is read-only, then the ReadOnlyBufferException is thrown.A program that demonstrates this is given as follows −Example Live Demoimport java.nio.*; import java.util.*; ... Read More

Advertisements