SQL date chnaged to datetime

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
SamRunyonAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
Use
DATEADD(hour, 10, YourDateColumn)
0
 
Anthony PerkinsCommented:
>>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
 
SamRunyonAuthor Commented:
thanks for the help.
Sam
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.