db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Format the timestamp value
Date Mon, 31 May 2010 14:33:50 GMT
On 05/30/2010 10:44 PM, kirru23 wrote:
> I tried using {fn timestampdiff(SQL_TSI_SECOND,
> current_timestamp,timestamp('1970-01-01-00.00.00')}
> But this doesnt give me the exact result as fetched by UNIX_TIMESTAMP
> function.

What was the difference? Is it due to time zone adjustments?

If the built-in Derby date/time functions are not quite meeting
your needs, you can write your own functions in Java, and call
them from your SQL:

http://wiki.apache.org/db-derby/DerbySQLroutines

thanks,

bryan

Mime
View raw message