I have the sample statement:
insert into "InvoiceLine" (CustomerRefListID, RefNumber, InvoiceLineItemRefListID, InvoiceLineDesc, InvoiceLineAmount, InvoiceLineRate, TxnDate) values ('8000013E-1233631679','2065:147098','80000002-1230754043','DeepCove' ,16.59, 16.59, 2008-12-20)
I have tried every combination of functions, single quotes, etc., but can not find the correct format for the txndate. Please let me know how the above statement should look with regard to the txndate.
Thanks,
Tim |