Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Unanswered: passing a date from VB6 to T-SQL

    Is there an advantage to defining the input parm in a stored procedure as datetime vs passing the date as a char and performing a convert within the stored procedure?

  2. #2
    Join Date
    Mar 2009
    Location
    Michigan
    Posts
    4
    depends on where you want the 'valid date' check to be. if you send in a string and convert fails, how will you handle that?

    if datetime is sent is, the you are good to go... in newer versions of sybase ase, there is a date data type.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •