Re: [despammed] Day name, month name from a datetime field

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