Postgres Pro
Downloads
Home   >   mailing lists

Re: [despammed] Day name, month name from a datetime field - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: [despammed] Day name, month name from a datetime field
Date
Msg-id 20050104130318.GA7083@Pinguin.wug-glas.de
Whole thread Raw
In response to Day name, month name from a datetime field  ("Deepa K" <kdeepa@midascomm.com>)
List pgsql-novice
Tree view 
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    ===

pgsql-novice by date:

Previous
From: "Deepa K"
Date:
Subject: Day name, month name from a datetime field
Next
From: Sukhdeep Johar
Date:
Subject: Re: pg_config missing in install