Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Unanswered: Pass-Through Query to DB2

    I am having trouble with pulling data from DB2 filtering by date.

    What are my options for date?

    I try using the following:
    WHERE mytable.datefield > Date()+15
    WHERE mytable.datefield > 2015-1-1
    WHERE mytable.datefield > 2015-1-1.00.00.000000
    WHERE mytable.datefield > #2015-1-1#

    Nothing is working. Got any ideas?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you are using a pass through query to connect to DB2, then use DB2 compliant SQL, not MS Access/JET ....
    https://www.google.co.uk/webhp?sourc...te%20functions
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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