Posted by Jerry Stuckle on 11/20/06 12:09

meltedown wrote:
> 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.

Why not? It's probably the most efficient way of doing it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: if i wanted to have the text i enter into a database be retrived formated the way i want it how could i do that
• Prev in forum: Re: Suggestions for creating thumbs after upload
• Thread view: Re: first day of month from sql date.

[Reply to this message]