Direct select - single quotation

Thu, 20 Jun 2013 06:32:05 GMT

Based on the QlikView Direct Discovery Addendum document there should be single quotation (') when using SQL function, like this:

DIRECT SELECT 'Month([OrderDate])' as OrderMonth FROM SalesOrder;

But what if the SQL function itself contains single quotation, like this TO_TIMESTAMP(EFFECTIVE_DATE,'MM/DD/YYYY HH:MI:SS AM').

Do you have some workaround? e.g. with combination of chr(39)?

topic Direct select - single quotation in QlikView