To compare dates in MySQL except time portion of a datetime field, you can use DATE() function. The syntax is as follows −select *from yourTableName where date(yourColumName) = yourDate;To understand the above concept, let us create a table. The query to create a table is as follows −mysql> create table ... Read More

The MySQL LIMIT is applied after ORDER BY. Let us check the limit condition. Firstly, we will create a table −mysql> create table LimitAfterOrderBy    −> (    −> Id int,    −> Name varchar(100)    −> ); Query OK, 0 rows affected (0.50 sec)Insert some records in the table ... Read More

To select timestamp data range, use the below syntax −SELECT *FROM yourTableName where yourDataTimeField >= anyDateRange and yourDataTimeField < anyDateRangeTo understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table DateRange −> ( ... Read More

In this program we will see how to convert BCD numbers to binary equivalent.Problem StatementA BCD number is stored at location 802BH. Convert the number into its binary equivalent and store it to the memory location 802CH.DiscussionIn this problem we are taking a BCD number from the memory and converting ... Read More

The microcomputer system basically consists of three blocksThe microprocessorThe memories of microprocessor like EPROM and RAMThe I/O ports by which they are connected.The possible data transfers are indicated below.Between the memory and microprocessor data transfer occurs by using the LDA and STA instructions.Between microprocessor and I/O ports also data transfer ... Read More

In this program we will see how to exchange a block of 10-byte data using 8085.Problem StatementWrite 8085 Assembly language program to exchange a block of data, where block size is 10.DiscussionThe data are stored at location 8010H to 8019H and 9010H to 9019H. The location 8000H is holding the ... Read More

Now let us see a program of Intel 8085 Microprocessor. This program will convert ASCII to binary values.Problem StatementWrite 8085 Assembly language program to convert ASCII to binary or Hexadecimal character values. DiscussionWe know that the ASCII of number 00H is 30H (48D), and ASCII of 09H is39H (57D). So all ... Read More

Every DMA channel consists an address register and a count register. These registers are 16-bits wide in length. In each 16 bits there are four ARs marked as AR3-0. Apart from four CRs there are control and status registers also. They are separate 8-bit registers, but have the same address. Here ... Read More

Now let us see a program of Intel 8085 Microprocessor. This program will convert ASCII to binary values.Problem StatementWrite 8085 Assembly language program to check whether a bit pattern is palindrome or not.DiscussionIn this program we are taking the number from location 8000H. The program will return 00H if the ... Read More

Now let us see a program of Intel 8085 Microprocessor. This program will find the multiplication result of two BCD numbers.Problem StatementWrite 8085 Assembly language program to find two BCD number multiplication. The numbers are stored at location 8000H and 8001H.DiscussionIn this program the data are taken from 8000H and ... Read More