Posted by petersprc on 11/20/06 05:53

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

• Next in forum: Re: first day of month from sql date.
• Prev in forum: 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
• Thread view: Re: first day of month from sql date.

[Reply to this message]