Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rounding Time to nearest 30 minutes

Gary FDec 28 2009 — edited Jan 2 2010
Good day,

I'm looking for a way to round the time portion of a date value. My query needs to return the time of day, rounded to the nearest 30 minutes - top of the hour or bottom of the hour.

If sysdate is: 12/28/2009 11:08:19 AM
I need to see: 12/28/2009 11:00:00 AM

If sysdate returns: 12/28/2009 11:18:19 AM
I need to see: 12/28/2009 11:30:00 AM

Any help is appreciated.

Regards,

Gary F.
This post has been answered by Frank Kulash on Dec 28 2009
Jump to Answer

Comments

gimbal2
Lol, you're trying to run 'java.exe' aren't you? Perhaps you should start at the beginning - with a book!
EJP
When I try to use it, I get a DOS window that pops up for an instant then disappears - then nothing else happens
That's what it's supposed to do. Your expectations are misplaced. What were you expecting? and why?
955403
How do I open a session in order to write JAVA code? What do I need to download then?
gimbal2
952400 wrote:
How do I open a session in order to write JAVA code? What do I need to download then?
A text editor. You did not download Visual Studio or something, you only have the tools to be able to compile and run stuff. Command line tools. Java is freedom and thus requires intelligence and reasoning to be able to use it properly, nobody is going to hold your hand and tell you what to use and how to do things. Its all up to you to discover that through reading, studying and experimentation. If that is not your thing you may want to consider switching to .NET.

There are also Integrated Development Environments (IDE) which are more complete, of which the most popular ones are Netbeans and Eclipse. You'll have to try them out to see which one you like more. But I would start with some basic research so you stop making wrong assumptions.
955403
Gimbal2 - Thank you for your time and trouble, and I will make one final stab at this: If I had wished to create a Word document, then I would open an MS Word session, type my sentences, and save the document. Likewise, I wish to open a Java session, type my logic, save it, compile it then execute it. It seems to me to be the most basic of requirements – or am I asking for too much?
EJP
You're asking for things that don't exist in the Java distribution, and you are just reiterating your erroneous assumptions instead of trying to learn from the very full reply you got from gimbal2.
955403
ok, thank you.
gimbal2
952400 wrote:
Gimbal2 - Thank you for your time and trouble, and I will make one final stab at this: If I had wished to create a Word document, then I would open an MS Word session, type my sentences, and save the document. Likewise, I wish to open a Java session, type my logic, save it, compile it then execute it. It seems to me to be the most basic of requirements – or am I asking for too much?
Its funny how you bring up Microsoft stuff as an example :) Really, Microsoft .NET with Microsoft Visual Studio. I have this 'feeling' that that's where you belong and you will thrive.

But yeah Eclipse or Netbeans when you want to "go Java". Like I already mentioned.
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 30 2010
Added on Dec 28 2009
12 comments
48,580 views