Sunday, October 2, 2016

I don't know why I havn't done an FPGA programming in my Btech?

I haven't got any hand on experience in FPGA programming in my Electronics and communication course in Thrissur Engineering College. But there is a subject for HDL and VLSI subjects. I am sure that I have studied HDL language in 5th semester or 7th and got just pass mark 40 out of 100. :-).  I do like that language because its gives clear idea on how the AND or OR or NAND  gates are used to build a small digital system.

But its very sad that haven't got any hand on in FPGA programming in my Btech.

Timing Analysis in Project IceStorm (Open Source iCE40 FPGA Flow)

Saturday, September 3, 2016

MYSQL- query for last one month count,last 60days,Feb month report generation








select SUM(CASE WHEN (DATE_FORMAT(order_date,'%m-%d-%y') > DATE_FORMAT(CURRENT_DATE - INTERVAL 30 DAY,'%m-%d-%y')) THEN 1 ELSE 0 END) AS ord,age from order1 group by age ;



select SUM(CASE WHEN (DATE_FORMAT(order_date,'%m-%d-%y') > DATE_FORMAT(CURRENT_DATE - INTERVAL 60 DAY,'%m-%d-%y')) THEN 1 ELSE 0 END) AS ord_from_60_days,SUM(CASE WHEN (DATE_FORMAT(order_date,'%m-%d-%y') > DATE_FORMAT(CURRENT_DATE - INTERVAL 30 DAY,'%m-%d-%y')) THEN 1 ELSE 0 END) AS ord_from_1month,age from order1 group by age ;


+------------------+-----------------+------+
| ord_from_60_days | ord_from_1month | age |
+------------------+-----------------+------+
| 7 | 4 | 23 |
| 0 | 0 | 25 |
+------------------+-----------------+------+
2 rows in set (0.00 sec)