timestamps and java epochs - Mailing list pgsql-jdbc

From Laurette Cisneros
Subject timestamps and java epochs
Date
Msg-id Pine.LNX.4.33.0108241221560.19179-100000@visor.corp.nextbus.com
Whole thread Raw
Responses Re: timestamps and java epochs  ("Thomas O'Dowd" <tom@nooper.com>)
List 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


pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: New backend functions?
Next
From: Ned Wolpert
Date:
Subject: Re: [HACKERS] Re: New backend functions?