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

Re: [despammed] How to get day of week?

From: Lloyd Dieter <ldieter(at)rochester(dot)rr(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [despammed] How to get day of week?
Date: 2004-12-21 13:28:24
Message-ID: 20041221082824.538782a4.ldieter@rochester.rr.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thank you, knew it had to be something simple.

-Lloyd

On Tue, 21 Dec 2004 13:42:17 +0100
Andreas Kretschmer <akretschmer(at)despammed(dot)com> wrote thusly:

> am  21.12.2004, um  7:28:25 -0500 mailte Lloyd Dieter folgendes:
> > 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...)
> 
> You search something like this:
> 
> select extract(dow from eingang) from a_buch ;
>        ^^^^^^^^^^^^^^^^^^^^^^^^^
> 
> 
> 
> 
> Regards, Andreas
> -- 
> Andreas Kretschmer    (Kontakt: siehe Header)
>                Tel. NL Heynitz:  035242/47212
> GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
>  ===    Schollglas Unternehmensgruppe    === 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org



In response to

pgsql-novice by date

Next:From: Keith WorthingtonDate: 2004-12-21 14:26:45
Subject: Using a timestamp in a WHERE clause
Previous:From: GeoffreyDate: 2004-12-21 13:24:28
Subject: Re: CAST and timestamp

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