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

From Gaetano Mendola
Subject Re: How to quote date value?
Date
Msg-id 3FBE52FC.3060503@bigfoot.com
Whole thread Raw
Responses Re: How to quote date value?
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




pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: cast varchar to numeric/money
Next
From: "Yudie"
Date:
Subject: Re: cast varchar to numeric/money