how to pass Date format "mm/dd/yyyy " to Sql Stored procedure
-
Dear all am new to c#(2008). i created a stored procedure in sql server 2000. "select * from employee where joindate between @d1 and @d1" I was using Table Adapter fill,get methods. when i tried to pass the date value which in "MM/dd/yyyy" it raises error message invalid datetime,then i declared DateTime variable and use Datetime.Parse(date in "MM/dd/yyyy"), DateTime.Parseexact,error not a valid datetime. i use Culture info ("en-US"),but no luck.
-
Dear all am new to c#(2008). i created a stored procedure in sql server 2000. "select * from employee where joindate between @d1 and @d1" I was using Table Adapter fill,get methods. when i tried to pass the date value which in "MM/dd/yyyy" it raises error message invalid datetime,then i declared DateTime variable and use Datetime.Parse(date in "MM/dd/yyyy"), DateTime.Parseexact,error not a valid datetime. i use Culture info ("en-US"),but no luck.
use
Convert(DateTime, '12/31/1920', 101)to convert properlt to datetime. Here 101 means you are passing in MM/dd/yyyy format. Check http://msdn.microsoft.com/en-us/library/aa226054(SQL.80).aspx[^] for more. :rose:Abhishek Sur My Latest Articles Working with Excel using MDAC
Basics on LINQ and Lambda Expressions
Create .NET Templates -
Dear all am new to c#(2008). i created a stored procedure in sql server 2000. "select * from employee where joindate between @d1 and @d1" I was using Table Adapter fill,get methods. when i tried to pass the date value which in "MM/dd/yyyy" it raises error message invalid datetime,then i declared DateTime variable and use Datetime.Parse(date in "MM/dd/yyyy"), DateTime.Parseexact,error not a valid datetime. i use Culture info ("en-US"),but no luck.
I hope you are NOT storing your date values as varchar in the database, you would be committing a major offence doing that. I use paramerterised queries and pass a date type into the sp. If I have to pass a string of a date to a proc I use 106 = "dd MMM yyyy" there is NO ambiguity in that format.
Never underestimate the power of human stupidity RAH