Обсуждение: Day name, month name from a datetime field

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

am  04.01.2005, um 17:43:34 +0530 mailte Deepa K folgendes:
> 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.

Yes. to_char(<field>, 'Day')

You can use this in a where-statement.


>
> 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.

Read the manual about to_char()


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
               Tel. NL Heynitz:  035242/47212
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===