Having trouble logging in or locating tickets ?


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

Hot Topics

[QODBC-ALL] Troubleshooting - Windows cannot find fqqbsav.exe

Solved: [QODBC-Desktop] Troubleshooting - Unable to change the default configuration of newly created QODBC DSN - Build 348

Solved: [QODBC-ALL] Troubleshooting - Unable to execute update statement when using SQL Server 2019 linked server on Windows 11 or Windows Server 2019

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

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

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

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 - 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).