From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Select date & time |
Date: | 2006-02-04 21:13:25 |
Message-ID: | 20060204211324.GB23797@KanotixBox |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Jan Danielsson <jan(dot)danielsson(at)gmail(dot)com> schrieb:
> This will yield an entry which looks something like:
>
> ts
> ---------------------------
> 2006-02-04 19:27:31.123456
>
> I'm interested in retaining this information in the database, but not
> when I'm going to present it. I.e. I want to be able to create a query
> that will return:
>
> date | time |
> -----------+----------+----
> 2006-02-04 | 19:27:31 |
Read the manual about to_char:
http://www.postgresql.org/docs/8.1/interactive/functions-formatting.html
and
http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2006-02-04 21:20:54 | Re: Backing Up |
Previous Message | Andreas Kretschmer | 2006-02-04 21:09:57 | Re: variables outside of functions |