Solved

SQL date chnaged to datetime

Posted on 2009-05-06
3
242 Views
Last Modified: 2012-05-06
I have a DB that has a date only.
I want to take the date and add 10:00
to each day.

So my querys will work with my other DB's that use 10:00am in the query.

any help?

Sam
0
Comment
Question by:SamRunyon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 24321443
Use
DATEADD(hour, 10, YourDateColumn)
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24321446
>>I have a DB that has a date only.<<
Incidentally all datetime data types have time.  In your case it is set to midnight or 0 hours.
0
 

Author Closing Comment

by:SamRunyon
ID: 31578812
thanks for the help.
Sam
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Updating statistics with error notification email in SQL server 4 126
INSERT DATE FROM STRING COLUMN 18 66
Replace Dates in query 14 57
SQL query with cast 38 64
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

732 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