Samual Sam has Published 2310 Articles

Ignoring the year in MySQL Query with date range?

Samual Sam

Samual Sam

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

669 Views

To ignore the year with date range, use the DATE_FORMAT() with the between clause. Let us first create a demo table. The query to create a table is as follows −mysql> create table igonreYearDemo    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> ShippingDate date ... Read More

FloatBuffer array() method in Java

Samual Sam

Samual Sam

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

208 Views

A float array for the buffer can be obtained using the method array() in the class java.nio.FloatBuffer. If the returned array is modified, then the contents of the buffer are also similarly modified and vice versa. If the buffer is read-only, then the ReadOnlyBufferException is thrown.A program that demonstrates this ... Read More

AlgorithmParameterGenerator generateParameters() method in Java

Samual Sam

Samual Sam

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

134 Views

The parameters can be generated using the method generateParameters() in the class java.security.AlgorithmParameterGenerator. This method requires no parameters and it returns the AlgorithmParameter object.A program that demonstrates this is given as follows −Example Live Demoimport java.security.*; import java.util.*; public class Demo {    public static void main(String[] argv) {     ... Read More

Duration toMillis() method in Java

Samual Sam

Samual Sam

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

172 Views

The value of a particular duration in the number of milliseconds can be obtained using the toMillis() method in the Duration class in Java. This method requires no parameters and it returns the duration in the number of milliseconds.A program that demonstrates this is given as follows −Example Live Demoimport java.time.Duration; ... Read More

LocalTime query() Method in Java

Samual Sam

Samual Sam

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

70 Views

The LocalTime object can be queried as required using the query method in the LocalTime class in Java. This method requires a single parameter i.e. the query to be invoked and it returns the result of the query.A program that demonstrates this is given as follows −Example Live Demoimport java.time.*; import ... Read More

C++ Program to Implement Hash Tables Chaining with Doubly Linked Lists

Samual Sam

Samual Sam

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

654 Views

A hash table is a data structure which is used to store key-value pairs. Hash function is used by hash table to compute an index into an array in which an element will be inserted or searched.This is a C++ program to Implement Hash Tables chaining with doubly linked lists.AlgorithmFor ... Read More

LocalTime plus() method in Java

Samual Sam

Samual Sam

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

220 Views

An immutable copy of a LocalTime where the required duration is added to it can be obtained using the plus() method in the LocalTime class in Java. This method requires two parameters i.e. the duration to be added and the TemporalUnit of the duration. Also, it returns the LocalTime object ... Read More

Provider entrySet() method in Java

Samual Sam

Samual Sam

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

140 Views

The entries in the Provider have an unmodifiable set view that can be obtained using the method entrySet() in the class java.security.Provider. This method requires no parameters and it returns the unmodifiable set view for the entries in the Provider.A program that demonstrates this is given as follows −Example Live Demoimport ... Read More

How to insert a row into a table that has only a single autoincrement column?

Samual Sam

Samual Sam

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

467 Views

You can easily insert a row into a table that has only a single auto increment column. The syntax is as follows −insert into yourTableName set yourColumnName =NULL;You can use the below syntax −insert into yourTableName values(NULL);To understand the above syntax, let us create a table. The query to create ... Read More

LocalTime isSupported() method in Java

Samual Sam

Samual Sam

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

87 Views

It can be checked if a ChronoUnit is supported by the LocalTime class or not by using the isSupported() method in the LocalTime class in Java. This method requires a single parameter i.e. the ChronoUnit to check. It returns true if the ChronoUnit is supported by the LocalTime class and ... Read More

Advertisements