Results 1 to 2 of 2

Thread: sql date

  1. #1
    Join Date
    Feb 2005
    Posts
    25

    Unanswered: sql date

    hi,

    i passed a date variable (eg variable name = salesdate, format = 2005-07-03) to my stored proedure and it does not work.

    however it works when i put the function curdate() in place of the variable.

    what can i be doing wrong?

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    A few questions:
    - What's the exact error?
    - What's the definition of the Stored Procedure?
    - Where does it fail (in the Pervasive Control Center or your application or both)?
    - What's the actual command to call the procedure that you're using?

    One suggestion:
    - Make sure the date is formatted properly (YYYY-MM-DD). It also needs to be enclosed in single quotes ('2005-03-07').
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

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