Greater than Date timestamp Query

    I'm need a SQL query that will display only records with a last modified date earlier than a specific date.


    Example: I want to locate all records with a last modified date earlier than 12/05/2005 (Examples: 11/20/2005, 12/01/2005, etc.)


    How can this be applied using a Where clause?

    Re: Greater than Date timestamp Query


    Don't know your database but here's some sample code


    Quote


    SELECT * FROM employee
    WHERE hire_date < '01 Jan 1993'
    order by hire_date asc

    Re: Greater than Date timestamp Query


    Oops... just noticed you said GREATER THAN


    Quote


    SELECT * FROM employee
    WHERE hire_date > '01 Jan 1993'
    order by hire_date asc

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login