| how to get time from server? [message #86305] |
Mon, 20 September 2004 21:34  |
samsul
Messages: 4
Registered: August 2004
|
Junior Member |
|
|
hai
can anyone teach me or show me the coding on how to get the time from the server.
my pc is connected to the server and i want to get the time from it.
thanks for helping
|
|
|
|
| Re: how to get time from server? [message #86322 is a reply to message #86305] |
Tue, 21 September 2004 05:44  |
Steve
Messages: 190
Registered: September 1999
|
Senior Member |
|
|
samsul -
if you are in a SQL environment then the code would be simply:
select to_char(sysdate, 'HH:MI:SS') from dual
You can also add AM/PM indicators if you like, or drop the seconds from the end. I would recommend reading on how to handle temporal data in Oracle SQL, the information is invaluable!
There are other ways of obtaining the current date/time in other environments (VB, JBDC, Beans, etc.)
HTH
Steve
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
