Postgres Pro
Downloads
Home   >   mailing lists

Day name, month name from a datetime field - Mailing list pgsql-novice

From Deepa K
Subject Day name, month name from a datetime field
Date
Msg-id 2097.192.168.13.85.1104840814.squirrel@192.168.13.85
Whole thread Raw
Responses Re: [despammed] Day name, month name from a datetime field  (Andreas Kretschmer <akretschmer@despammed.com>)
List pgsql-novice
Tree view 
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 by date:

Previous
From: Keith Worthington
Date:
Subject: Re: Creating a clean database
Next
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] Day name, month name from a datetime field