timestamps and java epochs

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: timestamps and java epochs
Date: 2001-08-24 19:23:33
Message-ID: Pine.LNX.4.33.0108241221560.19179-100000@visor.corp.nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I have a table in which there are two fields that are timestamps.

How do I parse these values back into epoch times? The
docs say that the values may come back in one of four formats,
how do I know which one I'll get? I can't seem to get JDBC to
take the "set datestyle" command (it throws an SQLException).

Even better: is there a database function I can use to turn these
things into a unix epoch time?

Thanks,

Laurette
Nextbus, Inc.
www.nextbus.com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2001-08-24 19:37:11 Re: Re: [JDBC] New backend functions?
Previous Message Bruce Momjian 2001-08-24 19:10:56 Re: Bug #428: Another security issue with the JDBC driver.