I have found it in documentation, it is single quote. But it does not explain why
SELECT '1/11/2003' AS "InvoiceDate";
returns "unknown" data type instead of "date".
Why not a string ? or a fancy custom type ?
Regards Gaetano Mendola
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]