You have a table containing birthdates (date field, including year)
and you want to display all rows for which the birthday will occur in
the next week (seven days).
You tried this query:
SELECT a017namaper, DATE_FORMAT(a017tkhlahir, '%e/%c/%Y') as
a017tkhlahir,
MONTH(a017tkhlahir) as bul
On 8/3/06, Penduga Arus <[EMAIL PROTECTED]> wrote:
On 8/1/06, Chris <[EMAIL PROTECTED]> wrote:
> Did you look at the link David sent you?
>
> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
thanks.. I manage to do that.. below is my solution. please advice if
there is any bet
On 8/1/06, Chris <[EMAIL PROTECTED]> wrote:
Did you look at the link David sent you?
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
thanks.. I manage to do that.. below is my solution. please advice if
there is any better solution
SELECT a017namaper, DATE_FORMAT(a017tkhla
Penduga Arus wrote:
On 7/31/06, Peter Lauri <[EMAIL PROTECTED]> wrote:
What version of MySQL do you have? Depending on that, there are different
methods.
MySQL 5, can you please show me how to do it..
Did you look at the link David sent you?
http://dev.mysql.com/doc/refman/5.0/en/date-and-t
On 7/31/06, Peter Lauri <[EMAIL PROTECTED]> wrote:
What version of MySQL do you have? Depending on that, there are different
methods.
MySQL 5, can you please show me how to do it..
thanks in advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
What version of MySQL do you have? Depending on that, there are different
methods.
-Original Message-
From: Penduga Arus [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 6:33 PM
To: mysql@lists.mysql.com
Subject: select between date
I want to do a program to display birthday for
July 2006 9:03 PM
To: mysql@lists.mysql.com
Subject: select between date
I want to do a program to display birthday for our staff. I have a
field named birthday with date format (-mm-dd), from this field I
want to display the staff who will have their birthday start from
current date to 7 days a
I want to do a program to display birthday for our staff. I have a
field named birthday with date format (-mm-dd), from this field I
want to display the staff who will have their birthday start from
current date to 7 days a head.
please help, thanks in advance
--
MySQL General Mailing List
F