| problem on time :( [message #86303] |
Mon, 20 September 2004 20:43  |
eboy
Messages: 17
Registered: August 2004
|
Junior Member |
|
|
hai
i got some problem about the time.
the time from the server is not the same as the time at my pc.
when i display the time from the server, the only thing is change is second e.g 10:15:15.. 10:15:59.... 10:15:01 after 59 seconds the minutes do not change and still 15.
is my coding below correct
select to_char(sysdate, 'hh24:mm:ss') into :datang.start_am
from sys.dual;
or you guys got another way to take the time from server
thanks for your help
regards
eboy
|
|
|
|
| Re: problem on time :( [message #86313 is a reply to message #86303] |
Tue, 21 September 2004 01:11  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
hi eboy,
ur code went wrong. u need to select mi instead of mm. mm signifies month. but i wonder why it is giving 15 though we have 12 months only.
or is it a typo??
by
vamsi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
