Re: select between date

2006-08-29 Thread Penduga Arus
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 a

Re: select between date

2006-08-03 Thread Penduga Arus
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

Re: select between date

2006-07-31 Thread Penduga Arus
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:

select between date

2006-07-31 Thread Penduga Arus
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