Tutorial by Examples: on

Monthwise difference between two dates(timestamp) select ( (DATE_PART('year', AgeonDate) - DATE_PART('year', tmpdate)) * 12 + (DATE_PART('month', AgeonDate) - DATE_PART('month', tmpdate)) ) from dbo."Table1" Yearwise difference between two dates...

Conditions: package should be at least installed. If not loaded in the current session, not a problem. ## Checking package version which was installed at past or ## installed currently but not loaded in the current session packageVersion("seqinr") # [1] ‘3.3.3’ packageVer...

To check the list of loaded packages search() OR (.packages())

A frequent reason why your read operation may not work is because your security rules reject the operation, for example because you're not authenticated (by default a database can only be accessed by an authenticated user). You can see these security rule violations in the Console output. But it's ...

Standard Version To install the standard version, go to the Plugin section of your WordPress installation. Search for "Advanced Custom Fields" and install/activate. You will now have access to a new area in the WordPress administrative area labeled "Custom Fields" where you can ...

The following table compares the features available(1) in EF Core and EF6.x. It is intended to give a high level comparison and does not list every feature, or attempt to give details on possible differences between how the same feature works. Creating a ModelEF6.xEF Core 1.0.0Basic modelling (cla...

<?php echo get_field('my_field_name', 'option'); ?> This will echo the value of "my_field_name" from the options page created via ACF.

A typical payment flow with Stripe can be divided in two steps: Client-side, in your frontend (HTML + Javascript) code, you collect the customer's payment information using Stripe's prebuilt Checkout form or Elements form field(s). This will return a token that you then send to your server. ...

Fabric.js is just like any other JS library just specific to canvas. Easy to setup and get started. All you need to do is download the fabric.js from HERE and include it in your project just like any other JS library for example the way you do it for jQuery. Then create the html file suppose index.h...

WKWebView resizes the fonts on web content so that a full-sized web page will fit on the device's form factor. If you want the web text in both portrait and landscape to be similar in size to the user's preferred reading size, you need to set it explicitly. Swift // build HTML header for dynamic t...

import javax.swing.JFrame; import javax.swing.SwingUtilities; import javax.swing.WindowConstants; public class Main { public static void main(String[] args) { SwingUtilities.invokeLater(() -> { JFrame frame = new JFrame("Hello World!"); frame...

Using java.lang.Runnable we make our "Hello World!" example available to Java users with versions dating all the way back to the 1.2 release: import javax.swing.JFrame; import javax.swing.SwingUtilities; import javax.swing.WindowConstants; public class Main { public static void ...

First Execute CREATE EXTENSION DBLINK; Then INSERT INTO <SCHEMA_NAME>.<TABLE_NAME_1> SELECT * FROM DBLINK( 'HOST=<IP-ADDRESS> USER=<USERNAME> PASSWORD=<PASSWORD> DBNAME=<DATABASE>', 'SELECT * FROM <SCHEMA_NAME>.<TABLE_NAME_2...

Installation CocoaPods CocoaPods is a dependency manager for Cocoa projects. You can install it with the following command: $ gem install cocoapods CocoaPods 1.1.0+ is required to build Alamofire 4.0.0+. To integrate Alamofire into your Xcode project using CocoaPods, specify it in your Po...

A very useful and logical follow-up to histograms and density plots would be the Empirical Cumulative Distribution Function. We can use the function ecdf() for this purpose. A basic plot produced by the command plot(ecdf(rnorm(100)),main="Cumulative distribution",xlab="x") wo...

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Cron extends CI_Controller { /** * This is default constructor of the class */ public function __construct() { parent::__construct(); $this->load->library('input'...

In application/hooks folder, create a file with name Blocker.php and paste the below code. <?php class Blocker { function Blocker(){ } /** * This function used to block the every request except allowed ip address */ function requestBlocker(){ ...

Android supports fingerprint api from Android 6.0 (Marshmallow) SDK 23 To use this feature in your app, first add the USE_FINGERPRINT permission in your manifest. <uses-permission android:name="android.permission.USE_FINGERPRINT" /> Here the procedure to follow ...

Apache JMeter segregated all the components into following groups based on their functionality: Test Plan: Starting point for scripting. JMeter saves the Test Plan in .jmx format. You add components to the Test Plan by Right Click on the Test Pand and navigating to the component you want to add. ...

In mysqld.cnf or equivalent: [mysql] prompt = '\u@\h [\d]> ' This achieves a similar effect, without having to deal with .bashrc's.