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

Trying to transform results of dow

From: Tan ga <gndtanga(at)mail(dot)pt>
To: pgsql-novice(at)postgresql(dot)org
Subject: Trying to transform results of dow
Date: 2002-10-17 09:31:06
Message-ID: 20021017102903.EAD11475FB7@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-novice
Hi I'm using extract(dow from table.field) and i would like to transform the
result into it's corresponding day.Ex:0 into Sunday

How can i do this?
-- 
Crie o seu email gratuito no mail.pt
http://www.mail.pt

Responses

pgsql-novice by date

Next:From: Andrew McMillanDate: 2002-10-17 10:58:10
Subject: Re: char() or varchar() for frequently used column
Previous:From: Jules AlbertsDate: 2002-10-17 09:23:30
Subject: Re: char() or varchar() for frequently used column

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