Having trouble logging in or locating tickets ?


RSS Feed
Posted by Rajendra Dewani (QODBC Support) on 27 September 2013 08:15 AM

Hot Topics

Solved: [QODBC-Desktop] Troubleshooting - QuickBooks 2022 - Could not start QuickBooks - Windows Server 2012 R2 & Windows Server 8

[QODBC-ALL] - Troubleshooting - QODBC Server Edition License Required - When using QODBC 2021 license

Troubleshooting - QODBC Online - Column not found - ARAgingSummary and APAgingSummary

[QODBC Online] - Upgrade QODBC Online to the latest version before December 17th, 2019

Troubleshooting - QODBC Online - There was an error while communicating with the Ids Server

Troubleshooting - If you get an error on QuickBooks Online click here

Troubleshooting - QODBC no longer licensed for this Reckon version

Troubleshooting - Unable to connect to QuickBooks POS 2015 (12.0) using Office 365 / 2016

Troubleshooting - Changes to the Integrated Application Authentication for QuickBooks.

Troubleshooting - Microsoft Access/Excel 2013 (Office 365 / 2016) Crash/QODBC ask for Activation/RegFile1 License error


Comments (2)
Having problems with QODBC syntax
16 December 2014 11:22 PM
I'm supposed to be pretty decent with Sql, have spent years on MS SQL, so I was surprised that I couldn't write a simple filtered select.
SELECT * FROM TimeTracking WHERE TxnDate > '2014-05-17' gets Invalid operand for operator.
I tried "2014-05-17" and d'2014-05-17' and '#2014-05-17#' which I think works in Access. I hate to go back to kindergarten, but is there a syntax manual for QODBC?
17 December 2014 10:02 AM

The time data in QODBC has its own formation. The date type format is {d 'YYYY-MM-DD'} and the time stamps format is {ts 'YYYY-MM-DD HH:MM:SS.SSS'} The time created field is time stamp type, so the correct query should be like below:


Date Format

SELECT * from TimeTracking WHERE Txndate >= {d '2005-09-23'}

Time Stamps Format

SELECT * FROM Customer WHERE TimeCreated = {ts '1999-07-29 14:24:18.000'}
SELECT * from InvoiceLine WHERE TimeModified >= {ts '2005-09-23 00:00:00.000'}

Please refer:
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).