Re: Compute difference between timestamps

On Sun, 04 Jun 2006 10:28:54 -0700, c8s3dw_at_verizon.net wrote:

> Cannot be implemented directly because to_date takes a character column
> argument, not a timestamp. So we convert to character first:

That's correct.> TO_DATE does not take "FF3". Also, date lacks the millisecond precision
> that I need.

Well, you said you wanted the results expressed as seconds, so I assumed you don't need millisecond. Obviously my assumption was incorrect. Try with "J" format, that's the only other thing I can think of.

-- 
http://www.mgogala.com