pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTimestamp, epoch and a bit confusion
3+ messages / 2 participants
[nested] [flat]
* Timestamp, epoch and a bit confusion
@ 2008-03-12 22:36 Valter Douglas Lisbôa Jr. <douglas@trenix.com.br>
2008-03-12 22:58 ` Re: Timestamp, epoch and a bit confusion Aurynn Shaw <ashaw@commandprompt.com>
0 siblings, 1 reply; 3+ messages in thread
From: Valter Douglas Lisbôa Jr. @ 2008-03-12 22:36 UTC (permalink / raw)
To: pgsql-sql
Hello all.
I working with postgreSQL for a couple of months, and now I trying to convert
timestamp columns in epoch and epoch to timestamp columns. So far I could
reach, all SQL I find by 'googling' returns an error.
Where can I find some documentation with this convertions fo 8.2.x branch? I
think the Manual on the main site is not very helpfull in this case!!! ;-(
Thanks in advance.
--
Valter Douglas Lisbôa Jr.
Sócio-Diretor
Trenix - IT Solutions
"Nossas Idéias, suas Soluções!"
www.trenix.com.br
contato@trenix.com.br
Tel. +55 19 3402.2957
Cel. +55 19 9183.4244
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Timestamp, epoch and a bit confusion
2008-03-12 22:36 Timestamp, epoch and a bit confusion Valter Douglas Lisbôa Jr. <douglas@trenix.com.br>
@ 2008-03-12 22:58 ` Aurynn Shaw <ashaw@commandprompt.com>
2008-03-13 00:41 ` Re: Timestamp, epoch and a bit confusion Valter Douglas Lisbôa Jr. <douglas@trenix.com.br>
0 siblings, 1 reply; 3+ messages in thread
From: Aurynn Shaw @ 2008-03-12 22:58 UTC (permalink / raw)
To: "Valter Douglas Lisbôa Jr." <douglas@trenix.com.br>; +Cc: pgsql-sql
Valter Douglas Lisbôa Jr. wrote:
> Hello all.
>
> I working with postgreSQL for a couple of months, and now I trying to convert
> timestamp columns in epoch and epoch to timestamp columns. So far I could
> reach, all SQL I find by 'googling' returns an error.
SELECT extract (epoch from your_time_field) from your_table;
SELECT to_timestamp(your_epoch_field) from your_table;
>
> Where can I find some documentation with this convertions fo 8.2.x branch? I
> think the Manual on the main site is not very helpfull in this case!!! ;-(
>
And you can check out the docs @
http://www.postgresql.org/docs/current/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
Hope that helps,
--
Aurynn Shaw
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 103
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
ashaw@commandprompt.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Timestamp, epoch and a bit confusion
2008-03-12 22:36 Timestamp, epoch and a bit confusion Valter Douglas Lisbôa Jr. <douglas@trenix.com.br>
2008-03-12 22:58 ` Re: Timestamp, epoch and a bit confusion Aurynn Shaw <ashaw@commandprompt.com>
@ 2008-03-13 00:41 ` Valter Douglas Lisbôa Jr. <douglas@trenix.com.br>
0 siblings, 0 replies; 3+ messages in thread
From: Valter Douglas Lisbôa Jr. @ 2008-03-13 00:41 UTC (permalink / raw)
To: pgsql-sql
Thank you, very much. I pass through extract(epoch from x).
On Wednesday 12 March 2008 19:58:07 Aurynn Shaw wrote:
> Valter Douglas Lisbôa Jr. wrote:
> > Hello all.
> >
> > I working with postgreSQL for a couple of months, and now I trying to
> > convert timestamp columns in epoch and epoch to timestamp columns. So far
> > I could reach, all SQL I find by 'googling' returns an error.
>
> SELECT extract (epoch from your_time_field) from your_table;
> SELECT to_timestamp(your_epoch_field) from your_table;
>
> > Where can I find some documentation with this convertions fo 8.2.x
> > branch? I think the Manual on the main site is not very helpfull in this
> > case!!! ;-(
>
> And you can check out the docs @
> http://www.postgresql.org/docs/current/static/functions-datetime.html#FUNCT
>IONS-DATETIME-EXTRACT
>
>
> Hope that helps,
> --
> Aurynn Shaw
>
> The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 103
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> ashaw@commandprompt.com
--
Valter Douglas Lisbôa Jr.
Sócio-Diretor
Trenix - IT Solutions
"Nossas Idéias, suas Soluções!"
www.trenix.com.br
contato@trenix.com.br
Tel. +55 19 3402.2957
Cel. +55 19 9183.4244
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-03-13 00:41 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-12 22:36 Timestamp, epoch and a bit confusion Valter Douglas Lisbôa Jr. <douglas@trenix.com.br>
2008-03-12 22:58 ` Aurynn Shaw <ashaw@commandprompt.com>
2008-03-13 00:41 ` Valter Douglas Lisbôa Jr. <douglas@trenix.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox