0

I have a complex sql query that I have in a stored procedure and am calling from C#.

The procedure requires a date-time which I pass in as DateTime object from c#, the problem seems to occur with the format of the date. If I change the parameter to string and pass it in as 'yyyy-MM-dd' it works fine.

Is there anyway to use the datetime object?

CheeseConQueso
  • 5,683
  • 27
  • 88
  • 126
LiamB
  • 17,715
  • 19
  • 74
  • 114

1 Answers1

3

Are you setting the stored procedure parameter SqlDbType property to SqlDbType.DateTime?

SqlParameter p = sqlCmd.Parameters.Add("@date", System.Data.SqlDbType.DateTime);

// set value
p.Value = DateTime.Now;

(update)

Also, I found this related question.

Community
  • 1
  • 1
bruno conde
  • 47,131
  • 14
  • 97
  • 117