There are lot of .NET helper assemblies that help you represent datetime in more readable formats, such as yesterday, 5 minutes ago, and so on. One of the libraries that
The format() method from SimpleDateFormat class helps to convert a Date object into certain format String objects by using the supplied pattern string. Date today = new Date();SimpleDateFormat dateFormat =
The HASHBYTES?function returns the MD2, MD4, MD5, SHA, SHA1, or SHA2 hash of a string. The next example returns a SHA1 hash value of it the string that was input.
During the development lifecycle, we may decide on a name for a table and later want to rename it based on the usage of the table. Let’s assume that there
You can use HttpResponse’s IsClientConnected property to figure out if the connection is still alive. Based on the value, you can kill a long-running process if the client is not
For a given number, it may be necessary to know the sign of the number for computation purposes. If it is positive, zero or negative, you may have respective case
Java provides the instanceof operator to test if an object is of a certain type, or a subclass of that type. The program can then choose to cast or not
SQL Server 2017 provides the CONCAT_WS function that allows you to concat a series of strings with a separator. Related Posts Germany Considers Limiting Chinese 5G TechUnderstandng Objects.deepEqualsiFOREX Keeps You
Go to Data Menu, choose the “From Web” option under the “Get External Data” section. Put a valid web page address, and click on “Import” button at the bottom. It
MySQL is capable of returning the result of a LIKE directly in the result set itself. For example, if you use a wildcard character in a query such as below,
Macros are to be scripted in VBA. However, you really don’t have to know VBA scripting to write a macro for your repeated tasks. Microsoft Office provides you a way
The ordinal() method on the enum returns the constant. In other words, you can assume this to be the same as index and similar to arrays the index starts with
In Java, objects can be cast explicitly and implicitly: implicit casting happens when the source type extends or implements the target type (casting to a superclass or interface). explicit casting
If you want the scripts to load at the end of the page load process, just add the “defer” keyword to the script tag. Such scripts will be executed when
At times, you need to create temporary files to perform certain actions. The following code segment illustrates the same: import java.io.*;public class CreateTempFile{ public static void main(String args[]) { CreateTempFile
We sometimes forget to turn debug to false or turn off tracing. You only need to set the following configuration in the machine.config file in the web server. It will
There are plenty of commands in MySQL that are supported for particular types of storage engines. We can use the following command to know the ENGINE type. SHOW TABLE STATUS
Use LocalDate and ChronoUnit: LocalDate date1 = LocalDate.of(2018, 8, 10); LocalDate date2 = LocalDate.of(2018, 8, 30); As long as the method between of the ChronoUnit enumerator takes 2 Temporals as
At times, your device can be exposed using multiple interface cards. The following code sample will help identify various interfaces and the related IP configuration available on them. import java.net.*;import
The java.util.Arrays class has an asList method to convert the argument array into a list. This will be handy when there are large amounts of information that you need to
To join the objects in a collection, such as a string array, with a common delimiter like a comma or another character, is quite easy with the string.join method. See
Instead of just traversing a list, this is a newer way of splitting and then iterating the list: import java.util.Arrays;import java.util.List;import java.util.Spliterator;public class UsingSpliterator{ public static void main(String args[]) {
Tableizer is an external app that is great for building HTML tables out of data, using existing Calc or Excel spreadsheet templates. You only need paste your cells into the
We often do String.ToUpper()?on two strings to compare them. This introduces additional overhead on string allocation. It is better to use OrdinalIgnoreCase?instead, as shown below: bool CompareResult = firstString.Equals(secondString, StringComparison.OrdinalIgnoreCase);
A list with a set of values can be reversed using the reverse() method. import java.util.*; public class ReverseACollection{ public static void main(String[] args) { List dataList = new ArrayList();
In order to copy, press the shift key and right-click the file for which you need the path. In the context menu that appears, you will find a new option
The difference is visible when you use the single quote with the + sign. The char value is converted to the ascii value and then summed up. However, you have
To be sure that you are seen on Google, and other search engine, searches, you should make sure that you have provided meta data about your website. Also, to make
The following statement shows the indices on a table in MySQL. SHOW INDEX FROM ‘LogMaster’ Related Posts Adding a New Column in a Specific PositionStackanetes Combines OpenStack and KubernetesAsus Zenbook
If you have multiple strings, you can use StringJoiner to join them efficiently. import java.util.StringJoiner;public class UsingStringJoiner{ public static void main(String args[]) { UsingStringJoiner usingStringJoiner = new UsingStringJoiner(); usingStringJoiner.proceed(); }