newbie:how can i get day of week data type...

From: "Muhammad Rusydi" <rusydi(at)cbn(dot)net(dot)id>
To: "postgres general" <pgsql-general(at)postgresql(dot)org>
Subject: newbie:how can i get day of week data type...
Date: 2001-06-14 10:23:53
Message-ID: 006201c0f4bc$39279be0$4f02a8c0@windows
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tamsin 2001-06-14 10:49:16 RE: newbie:how can i get day of week data type...
Previous Message Jeff Waugh 2001-06-14 09:41:30 Re: Permissions & Ownership (BUG?)