|
Posted by Pedro Graca on 11/20/06 10:17
meltedown wrote:
> If I have an sql date, such as "2006-11-19" is there a way using either
> sql or php date and time functions to get the date of the the first day
> of the month ?
select date_sub(YOUR_DATE_COLUMN, interval day(YOUR_DATE_COLUMN)-1 day)
from YOUR_TABLE;
--
I (almost) never check the dodgeit address.
If you *really* need to mail me, use the address in the Reply-To
header with a message in *plain* *text* *without* *attachments*.
Navigation:
[Reply to this message]
|