Consultor Eletrônico



Kbase P65556: Error (7481) when using SQL-92 date literal in query
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/16/2008
Status: Verified

FACT(s) (Environment):

Progress 9.1D

SYMPTOM(s):

Error using date literal in query

Inconsistent types (7481)

SELECT customer.name
FROM PUB.customer
WHERE customer.date >={d '2003-07-01'} AND customer.date<={d '2003-07-31'}

SQL-92

CAUSE:

Bug# 20030829-002

FIX:

Apply Service Pack 9.1D08 or higher.