Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I increment the minute component of a date column (Oracle 8.i) 1

Status
Not open for further replies.
speial

speial

Programmer
May 5, 2003
15
US
I have ben asked to increment the minute component of a date column by one. Does anyone have a suggestion on how to accomplish this ? We are using Oracle 8i.
 
Sort by date Sort by votes
Number constants added (or subtracted) to dates are interpreded as days, so anyDate+1 is the day after anyDate. A day has 1440 (=24*60) minutes. Same if you'd like to add 1 hour - would be anyDate+1/24.

Stefan


 
Upvote 0 Downvote
sadly, I have done it so often in "end date"s I have memorized that 86399/86400 added to a date makes it 11:59:59 at night

I tried to remain child-like, all I acheived was childish.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
395
Andrzejek
Andrzejek
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
335
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
195
Livia8
Livia8
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
2K
carp
carp
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
180
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top