> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of ..::rDk::.. > Sent: Sunday, September 07, 2008 8:08 PM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: [GENERAL] weekday from timestamp? > > im strugling with my dataset.. > > got a small pgsql db with a timestamp column in format YYYY:MM:DD > HH:MM:SS for each record > > how could i possibly return day of the week for every record? http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html