datetime query

[jed]

SELECT (hrs) AS total_hours,(mins)AS total_mins FROM Timerecords WHERE
(workdate between 02/06/2007 and 06/06/2007;

This statement doesn't work because it doesn't have times associated
with the dates.When i store the dates in the database originally it
automatically adds time to them is there anyway i can just enter dates
without the time.Any code examples please! thanks.

 

[Nicholas Paldino [.NET/C# MVP]]

You should be using a parameterized query for this. You would create
the query string like:

SELECT (hrs) AS total_hours,(mins)AS total_mins FROM Timerecords WHERE
(workdate between @from and @to);

And then you would add two parameters to the SqlCommand you are
generating. You would then set the value of those parameters to the date,
and it will do the rest for you (as well as convert the date to a value that
is not dependent on the locale, which is what you are doing).

 

[Guest]

jed,
this should be in one of the SQL Server newsgroups, it isn't about the C#
language at all.

DateTime database table columns normally store a complete datetime object
that includes the time. if you only supply a date, then 12:01 AM (or whatever
the database default is) becomes the default time for that column value.
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder(BETA): http://www.blogmetafinder.com

 

[jed]

SELECT (hrs) AS total_hours,(mins)AS total_mins FROM Timerecords WHERE
(workdate between 02/06/2007 and 06/06/2007;

This statement doesn't work because it doesn't have times associated
with the dates.When i store the dates in the database originally it
automatically adds time to them is there anyway i can just enter dates
without the time.Any code examples please! thanks.

Thanks all dont worry managed to sort it out