Mkotla has Published 118 Answers

How can I use MySQL INTERVAL keyword while extracting the part of the date?

mkotla
mkotla
Published on 19-Feb-2018 14:52:58
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             ... Read More

Why I got output 0(Zero) on converting date like ‘1965-05-15’ to TIMESTAMP?

mkotla
mkotla
Published on 19-Feb-2018 11:28:02
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, ... Read More

What is the difference between CHAR and NCHAR in MySQL?

mkotla
mkotla
Published on 19-Feb-2018 10:18:27
Both CHAR and NCHAR are fixed length string data types. They have the following differences −CHAR Data TypeNCHAR Data TypeIts full name is CHARACTER.Its full name is NATIONAL CHARACTERIt uses ASCII character setIt uses Unicode character set and data is stored in UTF8 formatIt occupies 1-byte of space for each ... Read More

What is onmouseup event in JavaScript?

mkotla
mkotla
Published on 16-Feb-2018 15:08:30
The onmouseup event triggers when a mouse button is released.ExampleYou can try to run the following code to learn how to work with onmouseup event in JavaScript −<html>    <head>       <script>          <!--             function sayHello() {     ... Read More

What are regular expressions in JavaScript?

mkotla
mkotla
Published on 16-Feb-2018 12:14:55
A regular expression is an object that describes a pattern of characters. The JavaScript RegExp class represents regular expressions, and both String and RegExp define methods that use regular expressions to perform powerful pattern-matching and search-and-replace functions on the text.A regular expression could be defined with the RegExp () constructor, as ... Read More

How to get the smallest integer greater than or equal to a number in JavaScript?

mkotla
mkotla
Published on 16-Feb-2018 11:23:25
To get the smallest integer greater than or equal to a number, use the JavaScript Math.ceil() method. This method returns the smallest integer greater than or equal to a number.ExampleYou can try to run the following code to get the smallest integer greater than or equal to a number −<html> ... Read More

How to use the submit button in HTML forms?

mkotla
mkotla
Published on 07-Feb-2018 12:21:46
Submit button automatically submits a form on click. Using HTML forms, you can easily take user input. The <form> tag is used to get user input, by adding the form elements. Different types of form elements include text input, radio button input, submit button, etc.Let’s learn about how to use ... Read More

How to take user input using HTML forms?

mkotla
mkotla
Published on 07-Feb-2018 11:27:23
Using HTML forms, you can easily take user input. The <form> tag is used to get user input, by adding the form elements. Different types of form elements include text input, radio button input, submit button, etc.Let’s learn about the <input> tag, which helps you to take user input using ... Read More

How can I clear or empty a StringBuilder in Java.

mkotla
mkotla
Published on 06-Feb-2018 14:58:42
You can either setLength to be 0 or create a new StringBuilder() instance. See the example below −Examplepublic class Tester {    public static void main(String[] args) {       StringBuilder builder = new StringBuilder();       builder.append("sample");       System.out.println(builder.toString());       builder.setLength(0);     ... Read More

How to concatenate byte array in java?

mkotla
mkotla
Published on 06-Feb-2018 12:50:35
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}; ... Read More
Previous 1 ... 4 5 6 7 8 9 10 ... 12 Next
Advertisements