From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Jeffery L Post <postjeff(at)uwm(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Time Formats |
Date: | 2001-01-12 23:11:08 |
Message-ID: | 20010112171108.A23909@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jan 12, 2001 at 04:47:35PM -0600,
Jeffery L Post <postjeff(at)uwm(dot)edu> wrote:
> On Fri, 12 Jan 2001, Bruno Wolff III wrote:
>
> I looked up the Function to_char it expects two passed variable COL and
> MASK. What is the format of the MASK that it expects and could you give an
> example of the use of this funcion in a query that returns multiple
> columns.
There is a lot of detail in the html documention on the different values
you can use in the mask. Here is a small example:
area=> select to_char(now(),'MM-DD HH:MM'), to_char(now(),'YYYY-MM');
to_char | to_char
-------------+---------
01-12 05:01 | 2001-01
(1 row)
From | Date | Subject | |
---|---|---|---|
Next Message | Ed Loehr | 2001-01-12 23:29:50 | Re: ODBC connect in ERWin |
Previous Message | Warren Vanichuk | 2001-01-12 23:10:56 | Re: ODBC connect in ERWin |