Time format
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Time format

  1. #1
    Join Date
    Sep 2000
    Hi all,
    at the sql prompt when i set timing on,
    what is the default format it shows up can we changet he format,coz i have set this to note the execution time for my query after execution it shows as
    Elapsed 00:01:92.81
    i would like to know what exactly this time means ..is it 1 minute and 92 seconds if so why is it not showing as 2 minutes and 30 seconds,
    please clarify,

  2. #2
    Join Date
    Aug 2001
    you have to set time on not timing on for your requirment ,,

    you will get time sql > prompt ...

    You can note down starting time and ending time for the queries so that you will get how much time taken to execute the query ..


Posting Permissions

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

Click Here to Expand Forum to Full Width