how do i pass a date parameter the data type

Results 1 to 2 of 2

Thread: how do i pass a date parameter the data type

  1. #1
    durgesh Guest

    Default how do i pass a date parameter the data type

    how do i pass a date parameter the data type of the field in the database is date time<BR>..<BR>..<BR>.....<BR>....<BR>set myfirstparam12=cmd.CreateParameter("givendate",adD ate,adParaminput, 7)<BR>cmd.parameters.append myfirstparam12 <BR>cmd("givendate")="21-apr-1999"<BR>cmd.execute&#037;&#062;<BR>....<BR><BR>i tried the above thing out <BR>but it does not seem to work<BR>

  2. #2
    gal Guest

    Default RE: how do i pass a date parameter the data type

    adDate uses a long not a string value to describe the date. you can use the adDBDate type and pass it a string of the format "yyyymmdd".

Posting Permissions

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