How to get day of week? - Mailing list pgsql-novice

From Lloyd Dieter
Subject How to get day of week?
Date
Msg-id 20041221072825.77715979.ldieter@rochester.rr.com
Whole thread Raw
Responses Re: [despammed] How to get day of week?  (Andreas Kretschmer <akretschmer@despammed.com>)
Re: How to get day of week?  (Jeffrey Melloy <jmelloy@visualdistortion.org>)
List pgsql-novice
I'm sure I'm missing something obvious, but this is the novice list, so
here goes:

Is there a function to return the day-of-week for a given time/datestamp?

What I'm looking for is something like:

select day(current_timestamp);

That would return the current day of the week (e.g. Monday/Tuesday...)

Thanks,

-Lloyd

pgsql-novice by date:

Previous
From: "Tjibbe Rijpma"
Date:
Subject: Re: Inheritance
Next
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] How to get day of week?