This is the last time

Results 1 to 2 of 2

Thread: This is the last time

  1. #1
    bobby Guest

    Default This is the last time

    how would i insert the date in to the sql <BR>should i use smalldatetime <BR><BR>how do i tell the sql server its the time in inputing<BR><BR>as i get the date format instead of the time<BR><BR>i tried date() to see what would happen and the time was inpputed<BR><BR>

  2. #2
    ahbao Guest

    Default RE: This is the last time

    from what i know<BR>should be...<BR>sqltext = "insert into tablename (ddate) values(#" & d & "#)"<BR><BR>dun use date or time as ur field names in the database<BR><BR>happy programming<BR><BR>regards,<BR>ahbao

Posting Permissions

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