Wednesday, December 28, 2011

Mysql Date Operation

1. Mysql Get first day of next month

SELECT (DATE_FORMAT(current_date ,'%Y-%m-01')) + interval 1 month;

2. Mysql Get first day of last month

SELECT (DATE_FORMAT(current_date ,'%Y-%m-01')) - interval 1 month;


at

Proxmox installation display out of range

Reference:  https://forum.proxmox.com/threads/proxmox-ve-screen-out-of-range.131297/

  • USB and Firewire Pinout
    Original Source:: http://www.zytrax.com/tech/pc/serial.html Tech Info - USB and Firewire USB and FireWire (IEEE 1394a and b) represent the...
  • [dos batch] Irfan view command line options
    Original Source :: http://en.irfanview-forum.de/viewtopic.php?t=490 /one - force 'Only one instance' /fs - force Full Screen displa...