Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Talking Unanswered: Select questions

    this based on Sample

    I tried to do this:

    db2 select firstnme,midinit,lastname,birthdate,YEAR(C
    URRENT DATE) - YEAR(birthdate) as age from employee where YEAR(CURRENT DATE) - YEAR(birthdate) between 65 and 1000


    It will give me a list who is older than 65

    but

    db2 select firstnme,midinit,lastname,birthdate,YEAR(C
    URRENT DATE) - YEAR(birthdate) as age from employee where YEAR(CURRENT DATE) - YEAR(birthdate) > 65

    wont work...

    Could anyone tell me why? Thanks

  2. #2
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    96
    Are you executing this from the command line?

    If so you need to surround your query with " , otherwise the '>' will be recognized as a output redirecter.

    If not, which message do you get?

  3. #3
    Join Date
    Nov 2003
    Posts
    4
    oh..yes, u r right... it output to a txt file

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    As GertK said, put double quotes around the select (but after the DB2 command) if issued from command prompt.

    This statement may be more accurate if want their exact age:

    SELECT
    firstnme,
    midinit,
    lastname,
    birthdate,
    year(current date - birthdate) as age
    FROM employee
    WHERE year(current date - birthdate) >= 65;
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •