Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived Development & Programming How to get first day of previous month
How to get first day of previous month
  • El Forum
    Guest
  •  
#6
07-29-2010, 05:10 AM

[eluser]Krzemo[/eluser]
From top of my head...
Code:
SELECT DATE_ADD(LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 2 MONTH)), INTERVAL 1 DAY)


Messages In This Thread
How to get first day of previous month - by El Forum - 07-29-2010, 04:46 AM
How to get first day of previous month - by El Forum - 07-29-2010, 04:50 AM
How to get first day of previous month - by El Forum - 07-29-2010, 04:59 AM
How to get first day of previous month - by El Forum - 07-29-2010, 05:01 AM
How to get first day of previous month - by El Forum - 07-29-2010, 05:07 AM
How to get first day of previous month - by El Forum - 07-29-2010, 05:10 AM



Theme © iAndrew 2016 - Forum software by © MyBB