Hi Prabhu, Select cols from tbl where datecolumn > date_add(datevar, interval 1 day); A look at Date and time functions of the manual would do good.
But you originally asked about sys_date (is it not sysdate pseudocolumn). Regards, Anvar At 04:49 PM 07/02/2002 +0530, you wrote: i am asking regarding a query . select DATE from table name where DATE > NEXT DAY(DATE). like this . could u write the query for me . ----- Original Message ----- From: Anvar Hussain K.M. <[EMAIL PROTECTED]> To: SNPrabhu <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 PM 04:29 Subject: Re: regarding mysql DATE support > Hi, > Now(), sysdate(). > Anvar. > > At 03:02 PM 07/02/2002 +0530, you wrote: > >Hai , > > > >is there any support of sys_date in mysql which is strong feature in oracle > >8.x . i am using MYSQL 3.23 server version . > > > > > >With Warm Regards > > > >[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 --------------------------------------------------------------------- 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
