Re: [despammed] How to get day of week?

Thank you, knew it had to be something simple.

-Lloyd

On Tue, 21 Dec 2004 13:42:17 +0100
Andreas Kretschmer <akretschmer@despammed.com> wrote thusly:

> am  21.12.2004, um  7:28:25 -0500 mailte Lloyd Dieter folgendes:
> > I'm sure I'm missing something obvious, but this is the novice list,
> > so here goes:
> >
> > Is there a function to return the day-of-week for a given
> > time/datestamp?
> >
> > What I'm looking for is something like:
> >
> > select day(current_timestamp);
> >
> > That would return the current day of the week (e.g. Monday/Tuesday...)
>
> You search something like this:
>
> select extract(dow from eingang) from a_buch ;
>        ^^^^^^^^^^^^^^^^^^^^^^^^^
>
>
>
>
> Regards, Andreas
> --
> Andreas Kretschmer    (Kontakt: siehe Header)
>                Tel. NL Heynitz:  035242/47212
> GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
>  ===    Schollglas Unternehmensgruppe    ===
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org