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 by mkotla
Page 8 of 8
How can I use MySQL INTERVAL keyword while extracting the part of the date?
With the help of following example we can understand that how we can use MySQL INTERVAL keyword with EXTRACT() function −mysql> Select StudentName, RegDate, EXTRACT(YEAR from RegDate+INTERVAL 2 year) AS 'Two Year Interval' from testing where StudentName = 'Gaurav'; +-------------+---------------------+-------------------+ | StudentName | RegDate | Two Year Interval | +-------------+---------------------+-------------------+ | Gaurav | 2017-10-29 08:48:33 | 2019 | +-------------+---------------------+-------------------+ 1 row in set (0.02 sec)Above query is showing how we can use INTERVAL keyword with EXTRACT() function used in MySQL table query.mysql> Select EXTRACT(Year from '2017-10-22 ...
Read MoreWhy I got output 0(Zero) on converting date like '1965-05-15' to TIMESTAMP?
As we know that with the help of MySQL UNIX_TIMESTAMP function, we can produce the number of seconds from given date/DateTime. But when we try to convert a date like ‘1965-05-15’ it would give 0(Zero) as output because the range of TIMESTAMP is between ‘1970-01-01 00:00:01’ to ‘2038-01-19 08:44:07’. Hence, the date values beyond TIMESTAMP range cannot be converted and will return 0 as output always.Examples are given below −mysql> Select UNIX_TIMESTAMP ('1965-05-15'); +----------------------------------------------+ | unix_timestamp('1965-05-15 05:04:30') | +----------------------------------------------+ | ...
Read MoreHow to concatenate byte array in java?
You ByteArrayOutputStream to write byte arrays and get the result using its toByteArray() method.import java.io.ByteArrayOutputStream; import java.io.IOException; public class Tester { public static void main(String[] args) throws IOException { byte[] a = { 1,2,3}; byte[] b = { 4,5,6}; ByteArrayOutputStream baos = new ByteArrayOutputStream(); baos.write(a); baos.write(b); byte[] c = baos.toByteArray(); for(int i=0; i< c.length ; i++){ System.out.print(c[i] +" "); } } }Output1 2 3 4 5 6
Read MoreDifference between Java SE, Java EE, and Java ME?
Java provides three editions JSE, JEE, JME. JSE − Java Standard Edition using this, you can develop stand-alone applications. This provides the following packages − java.lang − This package provides the language basics. java.util − This package provides classes and interfaces (API’s) related to collection framework, events, data structure and other utility classes such as date. java.io − This package provides classes and interfaces for file operations, and other input and output operations. java.math − This package provides classes and interfaces for multiprecision arithmetics. java.nio − This package provides classes and interfaces the Non-blocking I/O framework for Java java.net ...
Read MoreHow to set the first day of the week in sap.m.DatePicker's calendar?
I don’t think there is any recommended way to access internal calendar in Datepicker. I would suggest you raise a function request in Openui5 using GitHub.
Read MoreWhat is Java API and what is its use?
The full form of API is Application Programming Interface. It is a document which gives you the list of all the packages, classes, and interfaces, along with their fields and methods.Using these API’s, the programmer can know how to use the methods, fields, classes, interfaces provided by Java libraries.
Read MoreHow to declare a class in Java?
Following is the syntax to declare a class. class className { //Body of the class } You can declare a class by writing the name of the next to the class keyword, followed by the flower braces. Within these, you need to define the body (contents) of the class i.e. fields and methods.To make the class accessible to all (classes) you need to make it public. public class MyClass { //contents of the class (fields and methods) }
Read More