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,831
  • 29
  • 93
  • 126
LiamB
  • 18,243
  • 19
  • 75
  • 116

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,767
  • 15
  • 98
  • 117