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

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: [despammed] How to get day of week?
Дата
Msg-id 20041221124217.GA26887@Pinguin.wug-glas.de
обсуждение исходный текст
Ответ на How to get day of week?  (Lloyd Dieter <ldieter@rochester.rr.com>)
Ответы Re: [despammed] How to get day of week?  (Lloyd Dieter <ldieter@rochester.rr.com>)
Re: [despammed] How to get day of week?  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-novice
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    ===

В списке pgsql-novice по дате отправления:

Предыдущее
От: Lloyd Dieter
Дата:
Сообщение: How to get day of week?
Следующее
От: Geoffrey
Дата:
Сообщение: Re: CAST and timestamp