Re: [SQL] Timestamp, epoch and a bit confusion

2008-03-12 Thread Valter Douglas Lisbôa Jr.
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 ti

Re: [SQL] Timestamp, epoch and a bit confusion

2008-03-12 Thread Aurynn Shaw
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

[SQL] Timestamp, epoch and a bit confusion

2008-03-12 Thread Valter Douglas Lisbôa Jr.
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