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

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

From: Andreas Kretschmer <akretschmer(at)despammed(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [despammed] How to get day of week?
Date: 2004-12-21 12:42:17
Message-ID: 20041221124217.GA26887@Pinguin.wug-glas.de (view raw or flat)
Thread:
Lists: pgsql-novice
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    === 

In response to

Responses

pgsql-novice by date

Next:From: GeoffreyDate: 2004-12-21 13:24:28
Subject: Re: CAST and timestamp
Previous:From: Lloyd DieterDate: 2004-12-21 12:28:25
Subject: How to get day of week?

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