Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date - Mailing list pgsql-sql

From Emi Lu
Subject Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date
Date
Msg-id 48908404.2040804@encs.concordia.ca
Whole thread Raw
Responses Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date  ("Milen A. Radev" <milen@radev.net>)
Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date  (Bricklen Anderson <banderson@presinet.com>)
List pgsql-sql
Good morning,

Could someone tell me the command to get the weekly day name and day 
number please.


I am expecting something like:

sql> select data_part('day name', current_date);
sql> Monday

sql> select data_part('day number', current_date);
sql> 1

(Mon =1 ... Sun =7?)

Thanks a lot!


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Identifying which column matches a full text search
Next
From: "Milen A. Radev"
Date:
Subject: Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date