How to get Database or Server's System date and Time ???????? 
Author Message
 How to get Database or Server's System date and Time ????????

        How to get Database or Server's System date and time using SQL statement
or using API function or VB5. Please, send me a answer if anyone konow
that.
Thank You!

                                        Peter!



Fri, 10 Mar 2000 03:00:00 GMT  
 How to get Database or Server's System date and Time ????????

use the net time command from the dos prompt (or shell)

NET TIME [\\computer | /WORKGROUP:wgname] [/SET] [/YES]

  computer    Specifies the name of the computer (time
              server) whose time you want to check or
              synchronize your computer's clock with.
  /WORKGROUP  Specifies that you want to use the clock on a
              computer (time server) in another workgroup.
  wgname      Specifies the name of the workgroup containing
              a computer whose clock you want to check or
              synchronize your computer's clock with. If
              there are multiple time servers in that
              workgroup, NET TIME uses the first one it
              finds.
  /SET        Synchronizes your computer's clock with the
              clock on the computer or workgroup you
              specify.
  /YES        Carries out the NET TIME command without
              first prompting you to provide information or
              confirm actions.



Quote:
>    How to get Database or Server's System date and time using SQL statement
> or using API function or VB5. Please, send me a answer if anyone konow
> that.
> Thank You!

>                                    Peter!




Sat, 11 Mar 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. getting server's date and time

2. Compare date in form with date/time in form with date/time in database

3. Matching system date/time with field date/time

4. GETTING SYSTEM DATE AND TIME FROM BIOS

5. GETTING SYSTEM DATE AND TIME FROM BIOS

6. Getting NT server system time...

7. System time and date from a server

8. Retrieving date/time from Sql Server system tables

9. Getting Server date and time

10. Getting Date and time from the server

11. Getting DATE/TIME from a Server

12. Not getting all expected records due to date-time issue in the Oracle database

 

 
Powered by phpBB® Forum Software