Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

increment timestamp by 24 hours

Posted on 2014-10-06
3
Medium Priority
?
118 Views
Last Modified: 2014-10-17
hi experts

I have table USERLOCK
something like
Id        Lockedtime
1      2014-10-06 15:01:25.170

In my sql i need to return Lockedtime as 2014-10-07 15:01:25.170  (2014-10-06 15:01:25.170 + 24 hours )

select ID, Lockedtime+24 from USERLOCK 

Open in new window

doesnt seem to work , it increments by 24 days
any clue how i can increment the time by 24 hours?

thanks
0
Comment
Question by:royjayd
3 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 2000 total points
ID: 40364496
select ID, DATEADD(day, 1, Lockedtime) as Lockedtime from USERLOCK

Datetime values are stored internally as a double, where 1=a single day, so doing a +24 to a datetime would be the equialent of DATEADD(day, 24, Lockedtime).
0
 

Author Comment

by:royjayd
ID: 40364721
thanks
0
 
LVL 49

Expert Comment

by:PortletPaul
ID: 40365280
Just in case this is for a MySQL Timestamp field*

DATE_ADD(Lockedtime, INTERVAL 24 HOUR)

or

DATE_ADD(Lockedtime, INTERVAL 1 DAY)

----
:) * these might indicate MySQL: "timestamp" that means a date & time and "my sql"
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question