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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Time plus int

Status
Not open for further replies.
JChanana

JChanana

MIS
May 14, 2001
3
US
How do I take a datetime datatype (with a time only populated) and add a integer (where the data is already recorded in minutes) and add the two for the new time? Is there a conversion or a function that will help with this?
 
Sort by date Sort by votes

Try dateadd...

DATEADD(mi, 2, yourtime)

mi or n can be used to indicate the minute interval. Terry

X-) "I don't have a solution, but I admire your problem."
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
653
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Group results into one row 3
2
Replies
37
Views
2K
Chris Miller
Chris Miller
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
625
Chris Miller
Chris Miller
niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
383
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top