Posted by meltedown on 11/20/06 06:50

petersprc wrote:
> You could work on the text:
>
> $date = '2006-11-19';
> $newDate = substr($date, 0, strrpos($date, '-')) . '-01';
>
> meltedown wrote:
>> petersprc wrote:
>>> You could do something like this:
>>>
>>> <?
>>>
>>> function firstDayOfMonth($str = '2006-11-19')
>>> {
>>> $day = date('l', strtotime(date('Y/m/01', strtotime($str))));
>>> return $day;
>>> }
>>>
>>> echo firstDayOfMonth();
>>>
>>> ?>
>>>
>>> Change the date format string if you want other information about the
>>> first day of the month.
>>>
>>> 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 ?
>> Thanks, but I want the date, not the weekday. For 2006-11-19 it would be
>> 2006-11-01
>

Yes I know but I'd rather not.

[Back to original message]