Re: Time Formats

On Fri, 12 Jan 2001, Bruno Wolff III wrote:

> On Fri, Jan 12, 2001 at 02:02:28PM -0600,
>   Jeffery L Post <postjeff@uwm.edu> wrote:
> > Is there any way to have a time datatype returned in various formats?
> >
> > ex. 1:30 PM
> >
> > Maybe by setting a session variable?
>
> You can use to_char in a query to convert a date and/or time into a character
> string in the format you want.
>

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.