2, CURRENT_TIMESTAMP);
> 1 row inserted/updated/deleted
> ij> select {fn TIMESTAMPDIFF(SQL_TSI_SECOND, ts1,ts)} as TS_DIFF from
> atab1;
> TS_DIFF
> ---
> 0
> 0
>
> 2 rows selected
>
> HTH,
> -Rajesh
>
>
>
--
View this message in context:
http://old.nabble.com/Timestamp-Arithmetic-tp7342697p28199979.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
You learn something new every day. A whole aspect of JDBC of which I was
completely unaware.
Thanks Rajesh :)
Rajesh Kartha wrote:
Jose de Castro wrote:
I trying to calculate the duration (in seconds) between two
timestamps. Historically, I have either used a non-standard function
such as
Jose de Castro wrote:
I trying to calculate the duration (in seconds) between two
timestamps. Historically, I have either used a non-standard function
such as DateDiff in SQL Server and MySQL or performed a direct
arithmetic calculation (i.e. timestamp1-timestamp2) in PostgreSQL.
I have sear
I trying to calculate the duration (in seconds) between two timestamps.
Historically, I have either used a non-standard function such as
DateDiff in SQL Server and MySQL or performed a direct arithmetic
calculation (i.e. timestamp1-timestamp2) in PostgreSQL.
I have searched the reference docum
