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

Re: formating a select from a timestamp column

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: formating a select from a timestamp column
Date: 2005-11-19 08:06:08
Message-ID: 20051119080608.GA2325@kaufbach.delug.de (view raw or flat)
Thread:
Lists: pgsql-novice
stig erikson <stigerikson_nospam_(at)yahoo(dot)se> schrieb:

> 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?

There are any ways. A simple way is to cast the timestamp to a date:

test=# select now();
              now
-------------------------------
 2005-11-19 09:05:06.750268+01
(1 Zeile)

test=# select now()::date;
    now
------------
 2005-11-19
(1 Zeile)



HTH, Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

In response to

pgsql-novice by date

Next:From: A GilmoreDate: 2005-11-19 17:05:09
Subject: JOINing record returning function to query
Previous:From: A. KretschmerDate: 2005-11-19 07:42:54
Subject: Re: Logging

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