Depends on how you want to get it. All DBMS have a function to get the current time. MySQL, you can use the NOW() function and that will fetch the time on the server. If you are using Servlets of anykind, you could write a simple servlet to get the current time on the Server. Hope that points you in the right direction.
John Haake
Greenhorn
Joined: Jun 23, 2003
Posts: 10
posted
0
For an oracle database server: SELECT TO_CHAR( sysdate, 'HH24:MI:SS' ) FROM DUAL which, of course, returns a String result.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: How ti get the current time on the database server?