How to get the Database System Time using with SQL statement?????
Quote:
> How to get the Database or Server's System Time and Date using with
> SQL statement or other method in VB? Please, send me a answer if anyone
> know
> about that. Thank You!
> Peter.
Hi,
in cas of MS SQL Server you can issue the following SQL statement:
SELECT CURRENT_TIMESTAMP
It will bring you the following result:
---------------------------
Sep 24 1997 1:58PM
(1 row(s) affected)
I think that this depends on the Database you are using.
However no you have the solution for SQL Server...
Bye Michael
--
*********************************************************
Michael Jenc
CAS Software GmbH
Karlsruhe, Germany
Replace the '_' with '-' in E-mail address to contact me
