MySQL Forums
Forum List  »  General

Advanced Search
New Topic

comparing dates
Posted by: Anindya Mozumdar
Date: April 25, 2005 09:38AM

Hi,
I have two variables named emp_hire_dt and emp_term_dt in a table. I want to remove all employees whose termination date is before hire date. Will the following work -

delete from <tablename> where emp_term_dt < emp_hire_dt;

Thanks in advance.
Anindya.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
comparing dates
Anindya Mozumdar
April 25, 2005 09:38AM
Re: comparing dates
Felix Geerinckx
April 25, 2005 10:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.