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/

  • PHP Regular Expression Remove BBCODE
    How to remove BBCODE from a string ?   <?php  $String = "[b][color=#0000ff]TEST[/color][/b]"; $regex = '|[[\/\!]*?[^\[\]...
  • 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...