Quick Links

formating a select from a timestamp column

From:	stig erikson <stigerikson_nospam_(at)yahoo(dot)se>
To:	pgsql-novice(at)postgresql(dot)org
Subject:	formating a select from a timestamp column
Date:	2005-11-13 10:30:33
Message-ID:	dl74of$2b3o$1@news.hub.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-novice

hi i have a column that is declared as:
datum timestamp DEFAULT ('now'::text)::timestamp(6) with time zone

then i do:
SELECT datum from table;
and get something like: 2005-11-13 00:00:00

i would like the output to be on the format: 2005-11-13
how can i change it?

i use postgresql 8.1

thanks
stig

Re: formating a select from a timestamp column at 2005-11-19 08:06:08 from Andreas Kretschmer
Re: formating a select from a timestamp column at 2005-11-23 12:17:16 from Bruno Wolff III
Re: formating a select from a timestamp column at 2005-12-11 02:38:49 from Keith Worthington

	From	Date	Subject
Next Message	Kevin Lippiatt	2005-11-13 13:26:18	Install RPM Pre-req
Previous Message	dawizz	2005-11-13 09:49:16	Error: could not find function