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: 41C89BC8.3060000@visualdistortion.org (view raw or flat)
Thread:
Lists: pgsql-novice
The function you're looking for is to_char(), and it has tons of options.

http://www.postgresql.org/docs/7.4/static/functions-formatting.html

Jeff

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...)
>
>Thanks,
>
>-Lloyd
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>  
>


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-2014 The PostgreSQL Global Development Group