Varun has Published 83 Articles

How can I use any character, at the place of space, in MySQL TIMESTAMP to distinguish between date and time parts?

varun

varun

Updated on 29-Jan-2020 06:49:22

74 Views

We can use the only character ‘T’ (in Capital form only) at the place of space between date and time part. It can be elucidated with the help of the following example −mysql> Select TIMESTAMP('2017-10-20T06:10:36'); +----------------------------------+ | TIMESTAMP('2017-10-20T06:10:36') | +----------------------------------+ | 2017-10-20 06:10:36              | ... Read More

How MySQL behaves when we use INTERVAL of time unit with CURDATE() function?

varun

varun

Updated on 28-Jan-2020 10:52:40

64 Views

As we know that CURDATE() only returns the date unit so it would be ambiguous to use INTERVAL of time unit with CURDATE(). MySQL always represents current date with ‘00:00:00’ time hence when we use INTERVAL of time unit with CURDATE() then such kind of time arithmetic would take this ... Read More

What happens when MySQL encounters an out-of-range date?

varun

varun

Updated on 28-Jan-2020 10:13:49

306 Views

The response of MySQL on encountering out-of-range or invalid date will depend upon SQL MODE. If we have enabled ALLOW_INVALID_DATES mode then MySQL will convert the out of range values into all zeros (i.e. ‘0000:00:00 00:00:00’) and also stores the same in the table without producing any error or warning.For ... Read More

How to call a JavaScript function from an onClick event?

varun

varun

Updated on 08-Jan-2020 10:32:26

1K+ Views

The onClick event is the most frequently used event type, which occurs when a user clicks the left button of the mouse. You can put your validation, warning etc., against this event type.ExampleYou can try to run the following code to call a JavaScript function from an onClick eventLive Demo ... Read More

What is the difference between call and apply in JavaScript?

varun

varun

Updated on 02-Jan-2020 09:02:51

240 Views

In JavaScript, .call and .apply are considered a method of function object..call methodCount the number of arguments with call method. It accepts one or more arguments as objects.Here’s the syntax:.call(object, “argument1”, “argument2”);.apply method To use an array as an argument, use .apply. It requires an array as its 2nd argument.Here’s the ... Read More

Adding a text plus and text written from a parameter type C in ABAP

varun

varun

Updated on 10-Dec-2019 08:38:36

156 Views

This can be achieved by using String Expressions or by using CONCATENATE keyword. With the use of “Concatenate” operator && you can do this.To use String Expressions, you should check online documentation and sample programs by using T-code: ABAPDOCU as shown above.You can also refer to below link for ABAP ... Read More

Why is JavaScript case sensitive but HTML isn't?

varun

varun

Updated on 12-Sep-2019 08:28:32

268 Views

A script is in plain text and not just markup like HTML, which is case insensitive. In JavaScript, the while keyword should be "while", not "While" or "WHILE". Case sensitivity is important since it is closely related to HTML, but some methods and events are mentioned differently. JavaScrip has a ... Read More

Do we need to use semicolons in JavaScript?

varun

varun

Updated on 12-Sep-2019 08:05:42

112 Views

In JavaScript, Semicolons are optional. Simple statements in JavaScript are generally followed by a semicolon character, just as they are in C, C++, and Java. JavaScript, however, allows you to omit this semicolon if each of your statements is placed on a separate line. It is a good programming practice ... Read More

C# equivalent to Java's Thread.setDaemon?

varun

varun

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

219 Views

C# equivalent to Java's Thread.setDaemon is the concept of foreground and background threads. When the foreground threads will close, the background threads will be terminated. Foreground threads continue to run until the last foreground thread is terminated. The property used for background thread is IsBackground that gets or sets a ... Read More

What is CSS and why it is used?

varun

varun

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

220 Views

CSS handles the look and feel part of a web page. Using CSS, you can control the color of the text, the style of fonts, the spacing between paragraphs, how columns are sized and laid out, what background images or colors are used, layout designs, variations in the display for ... Read More

Advertisements