Hello Everyone and thanks for your help in advance. I am working on a application that passes parameters to a stored procedure similar to the following:

SELECT * From [tblVisits]

WHERE
    (CheckedIn BETWEEN @BeginningDate
    AND @EndingDate)

If today's date were the parameters, I would pass the following:

BeginningDate As DateTime = "3/15/2004 12:00:00 am"
EndingDate As DateTime = "3/15/2004 12:59:59 pm"

However, this only returns time prior to 1:00 pm. When I run the SPROC in Query Analyzer, I get the same results. But when I cahnge the ending time to 23:59:59 pm, it returns all of the records. In examining the databse, the dates are stored in the 12 hour format rather than the 24 hour format. I am not sure why this is occurring. Any help would be greatly appreciated.

I don't think you can use something like this "23:59:59 pm" as it does not seem to be a valid time format. When you say 23:59:59, you should not specipy "pm" there.

As you said the dates are stored in 12 hrs format, that is how the SQLServer stores the date values. But it provides you with a lot other formats with which you can query up on the date columns. Convert function is used to get any of those formats.

For example, when you want to pass the date values in 24hrs format as parameters, you can always use yyyy-mm-dd hh:mm:ss.mss format in your case, where value for hh can range from 00 - 23.

BeginningDate As DateTime = "2004-03-15 12:00:00.000"
EndingDate As DateTime = "2004-03-15 12:59:59.000"

eg:
Select Convert(varchar(25),getdate(),121) - gives you the format that is specified above.

Hope that helps.

Cheers,

-Vijay G

12:59:59pm is one second before 1pm. You need to change this end time to 11:59:59pm, that is one second before 12:00:00am.

I bet you push the door marked pull :-)



mmcdonal