newbie:how can i get day of week data type... - Mailing list pgsql-general

From Muhammad Rusydi
Subject newbie:how can i get day of week data type...
Date
Msg-id 006201c0f4bc$39279be0$4f02a8c0@windows
Whole thread Raw
Responses RE: newbie:how can i get day of week data type...  ("Tamsin" <tg_mail@bryncadfan.co.uk>)
Re: newbie:how can i get day of week data type...  (Jason Earl <jdearl@yahoo.com>)
List pgsql-general
i've created this table:
create table schedule (
day date,
tm timestamp,
room char(4));

insert into schedule values ('20/06/2001','08:00:00','A104');

my problem is how to get day of week information from date or is there any
way to do this?
would you show me how to do it?
thank's
Didi


pgsql-general by date:

Previous
From: Penguin
Date:
Subject: plpgsql & documentation / tutor
Next
From: "Tamsin"
Date:
Subject: RE: newbie:how can i get day of week data type...