Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
To part DATE and TIME from DATETIME, you can use the DATE_FORMAT() method from MySQL. The syntax is as follows −SELECT DATE_FORMAT(yourColumnName, '%Y-%m-%d') VariableName, DATE_FORMAT(yourColumnName, '%H:%i:%s') VariableName from yourTableName;To understand the above method DATE_FORMAT(), let us create a table with data type “datetime”.Creating a table −mysql> create table DateAndTimePartDemo -> ( -> YourDateandtime datetime -> ); Query OK, 0 rows affected (0.56 sec)Now, I am inserting current date and time using now(). The query is as follows −mysql> insert into DateAndTimePartDemo values(now()); Query OK, 1 row affected (0.37 sec)Display the record ... Read More
To check for duplicates in MySQL, you can use group by having clause. The syntax is as follows.select yourColumnName1, yourColumnName2, ......N, count(*) as anyVariableName from yourTableName group by yourColumnName1, yourColumnName2 having count(*) > 1;To understand the above syntax, let us create a table. The query to create a table is as follows.mysql> create table DuplicateDemo -> ( -> StudentId int not null, -> StudentFirstName varchar(100), -> StudentLastName varchar(100), -> Primary Key(StudentId) -> ); Query OK, 0 rows affected (0.50 sec)Insert some records in the table using insert command. The query is as follows.mysql> insert into DuplicateDemo values(1, 'John', 'Smith'); Query ... Read More
In this article we'll see how to compare two NSDates in swift. First of all we'll need to create two NSDates.We'll do it in playground instead of simulator this time.First Let's create two different dates.let dateOne = NSDateComponents() dateOne.day = 5 dateOne.month = 6 dateOne.year = 1993 let dateTwo = NSDateComponents() dateTwo.day = 4 dateTwo.month = 2 dateTwo.year = 1995Using these date components we'll create dates and then compare themlet cal = NSCalendar.current let FirstDate = cal.date(from: dateOne as DateComponents) let secondDate = cal.date(from: dateTwo as DateComponents)Now to compare them we'll use a if condition.if secondDate!.compare(firstDate!) == .orderedAscending { ... Read More
The class of large military weapons that are used to fire ammunition, are called as Artillery. These are used to target far ranges than the small arms can handle. The artillery includes Field and Infantry guns, Muzzle-loaded guns, Howitzers, Anti-aircraft and Anti-tank guns, heavy and Infantry mortars, Cannons and Autocannons, other large projectile weapons etc.When perfectly aimed, it could destroy the enemy trenches, can kill a group of soldiers or infantry, can destroy their ammunition and communication systems as well.China’s Song DynastyIt was during the middle ages, the artillery especially Cannons were introduced. Cannons which were widely used in wars, ... Read More
Plagiarism is the process of infringement which means presenting other’s work as one’s own. This is mostly done in the content field. The information from web pages, articles, blogs, books etc. is often copied by some to present it as their own work. As the process of content publishing online is increasing day-by-day there are many chances of having copied content, which can be either video, text or images.Google itPlagiarism tools help us identify that copied content. Usually, when we check on google to know whether this is genuine content, the copied part is immediately highlighted with the pages displaying ... Read More
In this program we will see how to generate Fibonacci sequence.Problem StatementWrite 8085 Assembly language program to generate the first ten elements of the Fibonacci sequence using registers only and store them in memory locations 8050H to 8059H. DiscussionThis program will generate the Fibonacci numbers. The Fibonacci numbers follows this relation F(i) = F(i - 1) + F(i - 2) for all i >2 with F(1) = 0, F(2) = 1.InputIn this case we are not providing any input, this program will generate ten Fibonacci numbers.Flow DiagramProgramAddressHEX CodesLabelsMnemonicsComments800021, 50, 80STARTLXI H 8050H Pointer to the OUT-BUFFER8003AFXRA A Clear accumulator and reg. B800447MOV B, ... Read More
UItableViewController and UIViewController are two different objects of iOS UIKit framework. Both are used for different purpose.A UIViewController class manages a ViewContoller which is responsible for actions that happen within that View controller. This class is aware of actions that happen on view controller, like ViewDidLoad, ViewWillApper, ViewDidAppear, ViewWillDisapper, ViewDidDisapper.Whereas, A UITableViewController is responsible for managing a table, it's data and it's events using UITableViewDataSource, UITableViewDelegate.A UITableViewController conforms to UIViewController, UITableViewDataSource and UITableViewDelegate to implement table view.Below is an example of a class implementing UIViewController.class ViewController : UIViewController { @IBOutlet weak var sampleView: UIView! ... Read More
This example demonstrates how do I make a dotted/dashed line in Android.Step 1 - Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 - Add the following code to res/layout/activity_main.xml. In the above code, we have text view with image view. Image view contains a dotted background. So create dotted.xml in drawable as shown below - Step 3 - Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import ... Read More
For random numbers in a range, you need to use the RAND() method from MySQL. The syntax is as follows for update −UPDATE yourTableName set yourColumnName=value where yourColumnName2=(SELECT FLOOR(1+RAND()*3));In the above query, the statement FLOOR(1+RAND()*3) generates the number between 1-3 and update the column.To understand the above syntax, let us first create a table. The query to create a table is as follows −mysql> create table updateRowWith1To3 -> ( -> Id int, -> Name varchar(100) -> ); Query OK, 0 rows affected (0.47 sec)Insert some records in the ... Read More
Now let us see a program of Intel 8085 Microprocessor. This program will convert 8-bit numbers to two digit ASCII values.Problem StatementWrite 8085 Assembly language program where an 8-bit binary number is stored in memory location 8050H. Separate each nibbles and convert it to corresponding ASCII code and store it to the memory location 8060H and 8061H.DiscussionIn this problem we are using a subroutine to convert one hexa-decimal digit (nibble) to its equivalent ASCII values. As the 8-bit number contains two nibbles, so we can execute this subroutine to find ASCII values of them. We can get the lower nibble ... Read More