Usage SQL statement

Discussion in 'Optigold ISP' started by paneolo, Oct 13, 2004.

0
  1. #1
    I'm trying to pull usage out of a mysql db, but it doesn't like the format yyyy/mm/dd that OG gives for the last date the import ran.

    So...I'm trying this

    date_format('<ATD> <ATT>', '%y-%m-%d %H:%i:%S')

    Which works great when testing against the database like this

    date_format('2004/10/12 0:00:00', '%y-%m-%d %H:%i:%S')

    But doesn't work when run through OG. Any ideas?
     
    paneolo, Oct 13, 2004 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    Are you testing it against the same database?
     
    digitalpoint, Oct 13, 2004 IP
  3. paneolo

    paneolo Guest

    Messages:
    57
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yes, it's against the exact same database. If I run it outside of OG, it works great, but if I run it inside OG it doesn't work. I checked the java companion log and it shows the query it ran as being date_format('2004/10/1 0:00:00', '%y-%m-%d %H:%i:%S') which works outside of OG, so I'm not sure why it's not working inside OG.

    Wait, I just found an extraneous single quote in the filemaker version and whala, it works. Now I feel a bit sheepish. Thanks for your help.
     
    paneolo, Oct 13, 2004 IP