Skip site navigation (1) Skip section navigation (2)

Re: How to get day of week?

From: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
To: Lloyd Dieter <ldieter(at)rochester(dot)rr(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to get day of week?
Date: 2004-12-21 21:55:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
The function you're looking for is to_char(), and it has tons of options.


Lloyd Dieter wrote:

>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...)
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?

In response to

pgsql-novice by date

Next:From: Keith WorthingtonDate: 2004-12-22 03:37:56
Subject: extracting min date and grouping
Previous:From: George WeaverDate: 2004-12-21 21:23:36
Subject: Re: JOIN columns with no data

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group