IL 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 that had all my
> >intelligence), I started thinking ab
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 rebui
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
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 those dates
that match 2
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 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.
Mark A. Bomgardner
Technolo
Hi there everyone,
I have the following 2 dates (FOr example):
19-02-2003
21-02-2003
How can I easily find out how many nights there are between the 2 dates? For example,
the above would be 2 nights as the 21st would be the checkout date.
I have the use the format about as that is how the in
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
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 the next month is depends on the
current month the script was ran)
ifer Downey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 5:26 PM
Subject: [PHP-DB] Date Question
> Hi all,
>
> If I have a feild called 'date' and the type is date when a form is
> submitted isn't it suppose to automatical
// -Original Message-
// From: Jennifer Downey [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 4 April 2002 8:27 AM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Date Question
//
//
// Hi all,
//
// If I have a feild called 'date' and the type is date when a form is
// submitted isn&#x
Hi all,
If I have a feild called 'date' and the type is date when a form is
submitted isn't it suppose to automatically enter the date or do I need to
somehow enter it through the form?
The reason I ask is that I have another form with a date type and no
reference to it in the form and it is al
14 matches
Mail list logo
