Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

Datetime add

I have DateTime "StartTime" and I would like to add day to it and also hours and minutes. How is best to do that?
0
johnkainn
Asked:
johnkainn
  • 2
1 Solution
 
Rajkumar GsSoftware EngineerCommented:
0
 
jppintoCommented:
SELECT DATEADD(dd, 1, StartTime()) Add1Day
0
 
Rajkumar GsSoftware EngineerCommented:
EG:- DATEADD(day, 1, StartTime)  -- TO ADD 1 DAY
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now