Re: How to quote date value? - Mailing list pgsql-sql

nobody wrote:
> 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