How do I add 1 hour to datetime SQL column data?

sql sql-server datetime getdate hour
Kelsey picture Kelsey · Apr 8, 2014 · Viewed 60.4k times · Source

I used this part of a query to create a table column for the date and time a row is added:

order_date datetime NOT NULL DEFAULT GETDATE()

and whenever a new row is created, the data for order_date is set to something like this:

Apr 8 2014 9:52AM

For some reason, when a row is created and the order_date column data is set, the hour is set 1 hour back. For example, the above column data for Apr 8 2014 9:52AM was set at 10:52AM.

Is there a way to set it 1 hour ahead so that it is correct with my current time?

Thank you for any help. All help is greatly appreciated.

Answer

Nathan picture Nathan · Apr 8, 2014

Use DATEADD()

DATEADD(hh, 1, order_date)

EDIT:

If the time is being set an hour back, you may have a wrong system time. So, it would be better if you just ask server admin to correct it.

Related questions

How to print GETDATE() in SQL Server with milliseconds in time?

I want to print GETDATE() in SQL Server 2008, I need the time with milliseconds (this is for debugging purpose - to find sp's execution time ) I find this Difference SELECT GETDATE() returns 2011-03-15 18:43:44.100 print GETDATE() returns Mar 15 2011 6:44PM I …

Read More
SQL - Select records for the same day between particular data range

I need to check the SQL date range between some values. Example. To check records added between last 2 to 1 hours. Is the below query correct: SELECT * FROM tablename WHERE dtdatetime BETWEEN DATEADD(hh, -1, GETDATE()) AND DATEADD(hh, -2, GETDATE()) …

Read More
Convert getdate() to EST

I would like to convert getdate() in SQL Server to EST time.

Read More