Re: How to quote date value?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Cc: nobody <nobody(at)nowhere(dot)near(dot)here>
Subject: Re: How to quote date value?
Date: 2003-11-21 18:01:32
Message-ID: 3FBE52FC.3060503@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Yudie 2003-11-21 18:26:57 Re: cast varchar to numeric/money
Previous Message Bruno Wolff III 2003-11-21 17:55:23 Re: cast varchar to numeric/money