Day name, month name from a datetime field

Поиск
Список
Период
Сортировка
От Deepa K
Тема Day name, month name from a datetime field
Дата
Msg-id 2097.192.168.13.85.1104840814.squirrel@192.168.13.85
обсуждение исходный текст
Ответы Re: [despammed] Day name, month name from a datetime field  (Andreas Kretschmer <akretschmer@despammed.com>)
Список pgsql-novice
Hi,
  I have a table which will have two datetime fields (logintime and
logouttime).

logintime : time at which the user is logged in
logouttime : time at which the user is logged out.

Is it possible to get the rows from table where the day is sunday.

And also is it possible to map the days in all rows to day name and similarly
is it possible to map the month in all rows to month name.

--
regards,
Deepa K

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

Предыдущее
От: Keith Worthington
Дата:
Сообщение: Re: Creating a clean database
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: [despammed] Day name, month name from a datetime field