Re: Retrieving a date.

Ken, Check out DAYOFMONTH() and MONTH() and a wealth of other useful date functions. RTFM: 6.3.4 Date and Time Functions The answer to your question about AUTO_INCREMENT 'reset' can be found at 6.5.3 CREATE TABLE Syntax under "table_options". Regards, =dn > I have a test table with the ususal customer information in it along with a > field for the date of birth. I'm trying to return records of any customers > whose birthdates are the same day and month as the current date. > Here's the query & result: > mysql> SELECT * FROM Cinfo WHERE BirthDate = "date('m d')"; > Empty set (0.00 sec) > Here's what is returned with a global query: > mysql> select * from Cinfo; > +-----------+----------+-------------------+---------+-------+--------+- -------------+--------------+--------------+------------+----+ > | FirstName | LastName | Address | City | State | Zip | > HomePhone | WorkPhone | CellPhone | BirthDate | id | > +-----------+----------+-------------------+---------+-------+--------+- -------------+--------------+--------------+------------+----+ > | Joe | Blow | 1200 High St. #12 | St.Looy | UT | 844110 | > 801-111-2299 | 801-111-3456 | 801-213-8956 | 1959-03-01 | 1 | > | | | | | | | > | | | | 2 | > | | | | | | | > | | | | 3 | > | | | | | | | > | | | | 4 | > +-----------+----------+-------------------+---------+-------+--------+- -------------+--------------+--------------+------------+----+ > 4 rows in set (0.00 sec) > > I have a feeling it's the date format in the table. I tried making it a date > field but just got the current date. What am I doing wrong? > Off Topic, I saw something about resetting the auto-increment counter, but > now I can't find reference to it. Can some kind soul enlighten me??? > -- > > > Ken Thompson, North West Antique Autos > Payette, Idaho > Email: ken@nwaa.com > http://www.nwaa.com > Sales and brokering of antique autos and parts. > > Linux- Coming Soon To A Desktop Near You > Registered Linux User #183936 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >