Hi,
format the datetime value before passing it as a parameter:
hrsAgo.ToString("yyyy-mm-dd");
Thanks
TFR.
On Sat, Feb 21, 2009 at 5:51 PM, SimonMartin
<[email protected]> wrote:
>
> Try setting the language of the database (or if possible the SQL
> Server instance) to British English rather than 'English' - this
> affects how SQL interprets dates. British date format is dd/MM/yyyy
> whereas US date format is MM/dd/yyyy
>
> On Feb 20, 5:10 pm, stapes <[email protected]> wrote:
>> Hi
>>
>> I have a web application written in ASP.NET C# and using SQL Server. I
>> am trying to select records with a date < a parameter.
>>
>> In SQL:
>>
>> @dtDateBefore datetime
>>
>> SELECT ... WHERE [log].dateTimeLogged < @dtDateBefore
>>
>> In C#:
>>
>> System.TimeSpan diff1 = new System.TimeSpan(48, 0, 0);
>> System.DateTime today = System.DateTime.Now;
>> System.DateTime hrsAgo = today.Subtract(diff1);
>> dsOpenJobs.SelectParameters.Add("dtDateBefore",
>> TypeCode.DateTime ,hrsAgo.ToString ());
>>
>> Trouble is, in ASP.NET my DateTime formats are dd/MM/yyyy. In SQL
>> server, they seem to be MM/dd/yyyy.
>>
>> How can I get this to run correctly?
>>
>> Stapes
>
