Board index » delphi » Getting server-side datetime
msson
Delphi Developer |
Wed, 18 Jun 1902 08:00:00 GMT
Getting server-side datetime
I am using MS SQL Server 6.5
and I want to get server side datetime using TQuery or TStoredProc. (1) If I write SQL property of TQUERY 'SELECT getdate()' (2) I made stored procedure like following ********************************************************************** as /* getting server datetime */ declare @serverdate datetime select @serverdate = getdate() select @serverdate GO GRANT EXECUTE ON dbo.sp_getdate TO public But this stored procedure doesn't work. How can I get server-side datetime ? |