How to get day of week?

From: Lloyd Dieter <ldieter(at)rochester(dot)rr(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to get day of week?
Date: 2004-12-21 12:28:25
Message-ID: 20041221072825.77715979.ldieter@rochester.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2004-12-21 12:42:17 Re: [despammed] How to get day of week?
Previous Message Tjibbe Rijpma 2004-12-21 08:27:05 Re: Inheritance