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: (view raw, whole thread or download thread mbox)
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
 ===    Schollglas Unternehmensgruppe    === 

In response to


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