This works perfect, Bastien!
Many thanks.
Gerry
On 3/13/06, Bastien Koert <[EMAIL PROTECTED]> wrote:
>
> select * from table where date_format(date_field, '%Y-%m') = '2006-02'
>
>
> bastien
>
>
> >From: "Gerry Danen" <[EMAIL PROTECTED]>
> >To: php-db@lists.php.net
> >CC: [EMAIL PROTECTED]
> >Sub
select * from table where date_format(date_field, '%Y-%m') = '2006-02'
bastien
From: "Gerry Danen" <[EMAIL PROTECTED]>
To: php-db@lists.php.net
CC: [EMAIL PROTECTED]
Subject: [PHP-DB] Date question
Date: Sun, 12 Mar 2006 20:44:13 -0700
While I am rebuilding my crashed laptop (the machine tha
Gerry Danen wrote:
While I am rebuilding my crashed laptop (the machine that had all my
intelligence), I started thinking about a select statement I need.
I have log info in a table and want to extract it on a monthly basis. The
date field is in -mm-dd format. What's a good way to select tho
For example, you have table `logs` with `datelog` field and you want to
select dates
that match 2006-02. You can try this select statement:
SELECT * FROM `logs` WHERE MONTH(datelog)='02' and YEAR(datelog)='2006'
Hope that helps.
LJ Regalado
Bomgardner, Mark A wrote:
I am having trouble converting a date from mm/dd/ to -mm-dd on a
user form. I know there was post about this, but I keep getting an
error message when I try to search the archives.
I have looked at the manual, but I am not finding what I am looking for.
echo date(
How are you trying to convert the date?
bastien
From: "Bomgardner, Mark A" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] Date Question
Date: Wed, 27 Oct 2004 11:17:16 -0500
I am having trouble converting a date from mm/dd/ to -mm-dd on a
user form. I know there was post ab
On Saturday 30 November 2002 12:30, Chris Payne wrote:
> Hi there everyone,
>
> I've never really used the date functions beyond getting it to store the
> current date in a db.
>
> I have a dilema in that I need to get all the days in the current month and
> all the days in the next month (whatever
It would seem that on the page that you post your form to, you'll need to
have a $date = date( "m.d.Y" ); to generate the actual date value.. That is
if I understand correctly the date() function and the question.
Later,
Bob Weaver
- Original Message -
From: "Jennifer Downey" <[EMAIL PR
Jennifer,
assuming you are using MySQL, then I would imagine the field which is
updating itself automatically is actually a TIMESTAMP type, rather than
plain DATE (or perhaps DATESTAMP?)
The *STAMP ones will update themselves I am pretty sure - but you might want
to check this.
HTH
Beau
// ---