Problem with times with Oracle Query
Hey all. So I'm running this query in SQL developer on an Oracle DB.
"select TO_CHAR(sysdate,'HH:MM:SS') from dual"
The problem is, it's returning the hour correctly, but the minute is always 09. If it just keep running it, the seconds will tick up to 59, but the minute always stays at 09. When the hour rolls over, the hour goes to the next one. Example at 8:30, it returns 8:09:SS, at 9:45 it will return 9:09:SS ect.
Anyone know what's up with this behavior? I've done the query using SQL developer, and just doing straight java code with the same results.