Skip site navigation (1) Skip section navigation (2)

Day name, month name from a datetime field

From: "Deepa K" <kdeepa(at)midascomm(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Day name, month name from a datetime field
Date: 2005-01-04 12:13:34
Message-ID: 2097.192.168.13.85.1104840814.squirrel@192.168.13.85 (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-novice by date

Next:From: Keith WorthingtonDate: 2005-01-04 12:15:56
Subject: Re: Creating a clean database
Previous:From: Sean DavisDate: 2005-01-04 11:58:09
Subject: Re: perl DBI and SQL COPY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group