Advertisement

12.18.2007 at 09:36AM PST, ID: 23031284
[x]
Attachment Details

Convert DateTime

Asked by quanmac in MS SQL Server

Tags: convert, datetime

Hi there,

I am trying to do the following comparison:

Invoice.Inv_Issue_Date + @minDays BETWEEN Event.Evnt_Start_Date AND Event.Evnt_Start_Date + 1

And I would like to set the time of Event.Evnt_Start_Date to 00:00AM to compare with because it is stored in the database with a time of 8:30AM and I would like to change that just in the comparision.

Not sure how I would accomplish this.Start Free Trial
[+][-]12.18.2007 at 09:45AM PST, ID: 20493892

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 09:48AM PST, ID: 20493912

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: convert, datetime
Sign Up Now!
Solution Provided By: dtodd
Participating Experts: 4
Solution Grade: A
 
 
[+][-]12.18.2007 at 11:07AM PST, ID: 20494475

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 11:25AM PST, ID: 20494626

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 11:52AM PST, ID: 20494841

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 11:54AM PST, ID: 20494861

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 12:22PM PST, ID: 20495083

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906