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
