Ask a Question related to ASP, Design and Development.

  1. #1

    Default Time query

    What should be SQL statement in asp to update time field
    (in MSACCESS) with current time?
    Bhavin Guest

  2. Similar Questions and Discussions

    1. Query Excution Time
      Question on query excution time. I have a mx application querying Oracle database, there is about ten records only, but the debugging information...
    2. query time
      On Wed, 02 Feb 2005 14:48:41 +0000, Richard Huxton <dev@archonet.com> wrote: Unfortunately, all my cases are LIKE '%john_doe'. So I'm guessing...
    3. Query Processing Time
      How can i set the Query Processing Time in my asp page. i am getting this error messages "Estimated query processing time 152 exceeds limit 30" ...
    4. Query execution time?
      Hi all, 1. Select * from table where ADEDATE = '23 June 2003' in SQLServer2000 This one works fine immediately. 2.Select * from table where...
    5. need advice for query time on Oracle
      jyou wrote: General statements are difficult to debug. For one thing, you have to take into account the network load ... since you're comparing a...
  3. #2

    Default Re: Time query

    strSQL = "UPDATE myTable SET myTimeField = Time()"

    Time() is an inbuilt VBA function that returns the current system time.

    Cheers
    Ken

    "Bhavin" <anonymous@discussions.microsoft.com> wrote in message
    news:06b301c397a0$cb4c90a0$a601280a@phx.gbl...
    : What should be SQL statement in asp to update time field
    : (in MSACCESS) with current time?


    Ken Schaefer Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139