Fri, Jun 08, 2001 at 06:20, Peter Eisentraut wrote:
> Julien Jehannet writes:
>
> > Well, this is my true problem:
> > I have converted my date format into the unix time
>
> Why? There's a DATE type.
Yes, I know. I'm using the TIMESTAMP type before but there exists some few
problems with the JDBC driver.
I read that new PostgreSQL can manage the Unix format but I'm sure that is more
efficient to test just a difference of seconds (with 2 integers) than several casts with timestamps and call an
function.
(I have a lot of tests of this kind)
Am I wrong ?? Furthemore, my applications must access to the Unix time format.
In your opinion, what is the best solution, int8 or numeric ??
Sincerely,
jul
--
(work) Julien.Jehannet at SecurityKeepers.com
(home) jhanet at caramail.com
'Early to rise and early to bed makes a man healthy but socially dead.'
Animaniacs, série burlesque américaine