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 better
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
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,
Hi,
Try here
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/*
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
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?