subject:"Re\: Another question of Date."

Re: Another question of Date.

2002-04-11 Thread Mike


http://www.mysql.com/doc/D/a/Date_and_time_functions.html

mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
- 'Saturday October 1997'
mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
- '22:23:00'
mysql select DATE_FORMAT('1997-10-04 22:23:00',
  '%D %y %a %d %m %b %j');
- '4th 97 Sat 04 10 Oct 277'
mysql select DATE_FORMAT('1997-10-04 22:23:00',
  '%H %k %I %r %T %S %w');
- '22 22 10 10:23:00 PM 22:23:00 00 6'
mysql select DATE_FORMAT('1999-01-01', '%X %V');
- '1998 52'


Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:42 AM
Subject: Another question of Date.


 Hi,

 I got a small problem I like to be able to read a DATE but I don't want to
 read the Year. I only want to read the month and the date. For example, I
 like to read the a Birthday Field to see who Bithday is today. Also like
to
 be later be able to read that same field but this time the year so that I
 can see how old a person is. Is there any example on the net of this?

 Chuck

 Sql and MySql


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Another question of Date.

2002-04-11 Thread Chuck \PUP\ Payne


Thanks but I want to be able able to use this in SQL statement not format
the output.

Chuck

on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:

 http://www.mysql.com/doc/D/a/Date_and_time_functions.html
 
 mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
   - 'Saturday October 1997'
 mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
   - '22:23:00'
 mysql select DATE_FORMAT('1997-10-04 22:23:00',
 '%D %y %a %d %m %b %j');
   - '4th 97 Sat 04 10 Oct 277'
 mysql select DATE_FORMAT('1997-10-04 22:23:00',
 '%H %k %I %r %T %S %w');
   - '22 22 10 10:23:00 PM 22:23:00 00 6'
 mysql select DATE_FORMAT('1999-01-01', '%X %V');
   - '1998 52'
 
 
 Mike
 - Original Message -
 From: Chuck PUP Payne [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, April 11, 2002 7:42 AM
 Subject: Another question of Date.
 
 
 Hi,
 
 I got a small problem I like to be able to read a DATE but I don't want to
 read the Year. I only want to read the month and the date. For example, I
 like to read the a Birthday Field to see who Bithday is today. Also like
 to
 be later be able to read that same field but this time the year so that I
 can see how old a person is. Is there any example on the net of this?
 
 Chuck
 
 Sql and MySql
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Another question of Date.

2002-04-11 Thread Mike

SELECT DATE_FORMAT(date column,'%W %M %Y') as date FROM table;

Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.

 Thanks but I want to be able able to use this in SQL statement not format
 the output.

 Chuck

 on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:

  http://www.mysql.com/doc/D/a/Date_and_time_functions.html

  mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
- 'Saturday October 1997'
  mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
- '22:23:00'
  mysql select DATE_FORMAT('1997-10-04 22:23:00',
  '%D %y %a %d %m %b %j');
- '4th 97 Sat 04 10 Oct 277'
  mysql select DATE_FORMAT('1997-10-04 22:23:00',
  '%H %k %I %r %T %S %w');
- '22 22 10 10:23:00 PM 22:23:00 00 6'
  mysql select DATE_FORMAT('1999-01-01', '%X %V');
- '1998 52'

  Mike
  - Original Message -
  From: Chuck PUP Payne [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Thursday, April 11, 2002 7:42 AM
  Subject: Another question of Date.

  Hi,

  I got a small problem I like to be able to read a DATE but I don't want
to
  read the Year. I only want to read the month and the date. For example,
I
  like to read the a Birthday Field to see who Bithday is today. Also
like
  to
  be later be able to read that same field but this time the year so that
I
  can see how old a person is. Is there any example on the net of this?

  Chuck

  Sql and MySql

  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)

  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
[EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

  ---
  Outgoing mail is certified Virus Free.
  Checked by AVG anti-virus system (http://www.grisoft.com).
  Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Another question of Date.

2002-04-11 Thread Mike

Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
function to supply a date for a WHERE clause in a sql statement.

Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.

 Thanks but I want to be able able to use this in SQL statement not format
 the output.

 Chuck

 on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:

  http://www.mysql.com/doc/D/a/Date_and_time_functions.html

  mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
- 'Saturday October 1997'
  mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
- '22:23:00'
  mysql select DATE_FORMAT('1997-10-04 22:23:00',
  '%D %y %a %d %m %b %j');
- '4th 97 Sat 04 10 Oct 277'
  mysql select DATE_FORMAT('1997-10-04 22:23:00',
  '%H %k %I %r %T %S %w');
- '22 22 10 10:23:00 PM 22:23:00 00 6'
  mysql select DATE_FORMAT('1999-01-01', '%X %V');
- '1998 52'

  Mike
  - Original Message -
  From: Chuck PUP Payne [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Thursday, April 11, 2002 7:42 AM
  Subject: Another question of Date.

  Hi,

  I got a small problem I like to be able to read a DATE but I don't want
to
  read the Year. I only want to read the month and the date. For example,
I
  like to read the a Birthday Field to see who Bithday is today. Also
like
  to
  be later be able to read that same field but this time the year so that
I
  can see how old a person is. Is there any example on the net of this?

  Chuck

  Sql and MySql

  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)

  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
[EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

  ---
  Outgoing mail is certified Virus Free.
  Checked by AVG anti-virus system (http://www.grisoft.com).
  Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Another question of Date.

2002-04-11 Thread Roger Baklund


* Chuck PUP Payne
 Thanks but I want to be able able to use this in SQL statement not format
 the output.

SELECT * 
  FROM 
table 
  WHERE 
DATE_FORMAT(birthday,'%M %D') = DATE_FORMAT(now(),'%M %D');

-- 
Roger
query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Another question of Date.

2002-04-11 Thread Chuck \PUP\ Payne


Mike and the mysql list,

This is the SQL statement I am using now;

SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM
emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =7 AND (TO_DAYS(D\
OB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB,
Lname

But it only works because I had to change the year to 2002, I don't want to
change 2002. That was my question I want to read the field but only the
month and the date. NOT FORMAT.  I also like to read that field but only the
year and take this year to get how old a person is. I hope that clears it
up.

Chuck
on 4/11/02 8:02 AM, Mike at [EMAIL PROTECTED] wrote:

 Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
 function to supply a date for a WHERE clause in a sql statement.
 
 Mike
 - Original Message -
 From: Chuck PUP Payne [EMAIL PROTECTED]
 To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Thursday, April 11, 2002 7:53 AM
 Subject: Re: Another question of Date.
 
 
 Thanks but I want to be able able to use this in SQL statement not format
 the output.
 
 Chuck
 
 on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
 
 http://www.mysql.com/doc/D/a/Date_and_time_functions.html
 
 mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
   - 'Saturday October 1997'
 mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
   - '22:23:00'
 mysql select DATE_FORMAT('1997-10-04 22:23:00',
 '%D %y %a %d %m %b %j');
   - '4th 97 Sat 04 10 Oct 277'
 mysql select DATE_FORMAT('1997-10-04 22:23:00',
 '%H %k %I %r %T %S %w');
   - '22 22 10 10:23:00 PM 22:23:00 00 6'
 mysql select DATE_FORMAT('1999-01-01', '%X %V');
   - '1998 52'
 
 
 Mike
 - Original Message -
 From: Chuck PUP Payne [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, April 11, 2002 7:42 AM
 Subject: Another question of Date.
 
 
 Hi,
 
 I got a small problem I like to be able to read a DATE but I don't want
 to
 read the Year. I only want to read the month and the date. For example,
 I
 like to read the a Birthday Field to see who Bithday is today. Also
 like
 to
 be later be able to read that same field but this time the year so that
 I
 can see how old a person is. Is there any example on the net of this?
 
 Chuck
 
 Sql and MySql
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
 
 
 
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Another question of Date.

2002-04-11 Thread Chuck \PUP\ Payne


Sorry that second 2002 should be year. I don't want to change year to get it
to work.

Chuck
on 4/11/02 8:10 AM, Chuck PUP Payne at [EMAIL PROTECTED] wrote:

 Mike and the mysql list,
 
 This is the SQL statement I am using now;
 
 SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM
 emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =7 AND (TO_DAYS(D\
 OB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB,
 Lname
 
 But it only works because I had to change the year to 2002, I don't want to
 change 2002. That was my question I want to read the field but only the
 month and the date. NOT FORMAT.  I also like to read that field but only the
 year and take this year to get how old a person is. I hope that clears it
 up.
 
 Chuck
 on 4/11/02 8:02 AM, Mike at [EMAIL PROTECTED] wrote:
 
 Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
 function to supply a date for a WHERE clause in a sql statement.
 
 Mike
 - Original Message -
 From: Chuck PUP Payne [EMAIL PROTECTED]
 To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Thursday, April 11, 2002 7:53 AM
 Subject: Re: Another question of Date.
 
 
 Thanks but I want to be able able to use this in SQL statement not format
 the output.
 
 Chuck
 
 on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
 
 http://www.mysql.com/doc/D/a/Date_and_time_functions.html
 
 mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
   - 'Saturday October 1997'
 mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
   - '22:23:00'
 mysql select DATE_FORMAT('1997-10-04 22:23:00',
 '%D %y %a %d %m %b %j');
   - '4th 97 Sat 04 10 Oct 277'
 mysql select DATE_FORMAT('1997-10-04 22:23:00',
 '%H %k %I %r %T %S %w');
   - '22 22 10 10:23:00 PM 22:23:00 00 6'
 mysql select DATE_FORMAT('1999-01-01', '%X %V');
   - '1998 52'
 
 
 Mike
 - Original Message -
 From: Chuck PUP Payne [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, April 11, 2002 7:42 AM
 Subject: Another question of Date.
 
 
 Hi,
 
 I got a small problem I like to be able to read a DATE but I don't want
 to
 read the Year. I only want to read the month and the date. For example,
 I
 like to read the a Birthday Field to see who Bithday is today. Also
 like
 to
 be later be able to read that same field but this time the year so that
 I
 can see how old a person is. Is there any example on the net of this?
 
 Chuck
 
 Sql and MySql
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
 
 
 
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
 
 
 
 -
 Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Another question of Date.

2002-04-11 Thread Land, Christopher


About midway down the page...:

http://www.mysql.com/doc/S/t/String_functions.html

SUBSTRING(str,pos) 
SUBSTRING(str FROM pos) 
Returns a substring from string str starting at position pos: 
mysql select SUBSTRING('Quadratically',5);
- 'ratically'
mysql select SUBSTRING('foobarbar' FROM 4);
- 'barbar'

This function is multi-byte safe. 

C:~

-Original Message-
From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 5:10 AM
To: Mike; [EMAIL PROTECTED]
Subject: Re: Another question of Date.


Mike and the mysql list,

This is the SQL statement I am using now;

SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM
emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =7 AND (TO_DAYS(D\
OB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB,
Lname

But it only works because I had to change the year to 2002, I don't want to
change 2002. That was my question I want to read the field but only the
month and the date. NOT FORMAT.  I also like to read that field but only the
year and take this year to get how old a person is. I hope that clears it
up.

Chuck
on 4/11/02 8:02 AM, Mike at [EMAIL PROTECTED] wrote:

 Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
 function to supply a date for a WHERE clause in a sql statement.
 
 Mike
 - Original Message -
 From: Chuck PUP Payne [EMAIL PROTECTED]
 To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Thursday, April 11, 2002 7:53 AM
 Subject: Re: Another question of Date.
 
 
 Thanks but I want to be able able to use this in SQL statement not format
 the output.
 
 Chuck
 
 on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
 
 http://www.mysql.com/doc/D/a/Date_and_time_functions.html
 
 mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
   - 'Saturday October 1997'
 mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
   - '22:23:00'
 mysql select DATE_FORMAT('1997-10-04 22:23:00',
 '%D %y %a %d %m %b %j');
   - '4th 97 Sat 04 10 Oct 277'
 mysql select DATE_FORMAT('1997-10-04 22:23:00',
 '%H %k %I %r %T %S %w');
   - '22 22 10 10:23:00 PM 22:23:00 00 6'
 mysql select DATE_FORMAT('1999-01-01', '%X %V');
   - '1998 52'
 
 
 Mike
 - Original Message -
 From: Chuck PUP Payne [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, April 11, 2002 7:42 AM
 Subject: Another question of Date.
 
 
 Hi,
 
 I got a small problem I like to be able to read a DATE but I don't want
 to
 read the Year. I only want to read the month and the date. For example,
 I
 like to read the a Birthday Field to see who Bithday is today. Also
 like
 to
 be later be able to read that same field but this time the year so that
 I
 can see how old a person is. Is there any example on the net of this?
 
 Chuck
 
 Sql and MySql
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
 
 
 
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Another question of Date.

2002-04-11 Thread Basil Hussain


Hi,

 I got a small problem I like to be able to read a DATE but I don't want to
 read the Year. I only want to read the month and the date. For example, I
 like to read the a Birthday Field to see who Bithday is today.
 Also like to
 be later be able to read that same field but this time the year so that I
 can see how old a person is. Is there any example on the net of this?

I think what you really want is the following functions:

* DAYOFMONTH()
* MONTH()
* YEAR()

They all take as an argument a date field and return the appropriate part of
the date. There are similar functions for hours, mins, secs, etc. See this
section of the manual for more info:

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

So, using your example of finding all records with date of birth the same as
today, regardless of year, we would issue a query like this:

SELECT dob FROM yourtable WHERE MONTH(dob) = MONTH(NOW()) AND
DAYOFMONTH(dob) = DAYOFMONTH(NOW());

And, to see how old a person is, given their date of birth, you would do
something like this:

SELECT YEAR(NOW() - YEAR(dob) AS age FROM yourtable;

Hope this helps.

Regards,

Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Another question of Date.

Re: Another question of Date.

Re: Another question of Date.

Re: Another question of Date.

RE: Another question of Date.

Re: Another question of Date.

Re: Another question of Date.

RE: Another question of Date.

RE: Another question of Date.

9 matches

Site Navigation

Mail list logo

Footer information