"落叶风中舞" <[email protected]> writes: > hello: > How to get database time use sql clause in Derby?
Hi, You can use the functions CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP to get the time using SQL. For example: ij> values current_time; 1 -------- 23:59:52 1 row selected ij> values current_timestamp; 1 ----------------------------- 2011-01-25 23:59:55.525 1 row selected ij> values current_date; 1 ---------- 2011-01-26 1 row selected -- Knut Anders
