Board index » delphi » Getting server-side datetime

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()'
I got general SQL Error. Cant' I use MS SQL function like getdate() in
TQuery component ?

(2) I made stored procedure like following

**********************************************************************
create procedure sp_getdate

as

/*   getting server datetime  */

declare  @serverdate datetime

select @serverdate = getdate()

select @serverdate

GO

GRANT  EXECUTE  ON dbo.sp_getdate  TO public
GO
**********************************************************************

But this stored procedure doesn't work.

How can I get server-side datetime ?
Any advice will be appreciated.

 

Re:Getting server-side datetime


I just tried
    SELECT getdate()
against SQL Server 7.0 and 6.5 from the DB Explorer and it worked fine.

Lately I have used several SQL statements executed from TQueries that use
getdate() and they work fine.

Your TQuery object should have RequestLive set to FALSE.  Make sure you use
Open() instead of ExecSQL().

HTH

Mark Lauter
Independent Contractor
Find a few Free Delphi and C++ Builder components here...
http://home.tampabay.rr.com/marknmarilynn/

Quote
mssong <mss...@somansa.co.kr> wrote in message

news:7mfiea$fv5@forums.borland.com...
Quote
> 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()'
> I got general SQL Error. Cant' I use MS SQL function like getdate() in
> TQuery component ?

> (2) I made stored procedure like following

> **********************************************************************
> create procedure sp_getdate

> as

> /*   getting server datetime  */

> declare  @serverdate datetime

> select @serverdate = getdate()

> select @serverdate

> GO

> GRANT  EXECUTE  ON dbo.sp_getdate  TO public
> GO
> **********************************************************************

> But this stored procedure doesn't work.

> How can I get server-side datetime ?
> Any advice will be appreciated.

Re:Getting server-side datetime


Hi, mssong

1) Use this store procedure

create procedure sp_getdate ( @serverdate datetime out )
as
begin
/*   getting server datetime  */
select @serverdate = getdate()
end

2) In the  TQuery Component you have to use this line
    exec sp_getdate :serverdate out
3) Define this parameter In the  TQuery Component as Output
4) Execute using
    Query1.ExecSql;
    VaraibleDateTime := Query1.FieldByName('serverdate').value;

Claudio Taboada
Delphi Developer's

Quote
mssong wrote in message <7mfiea$...@forums.borland.com>...
>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()'
>I got general SQL Error. Cant' I use MS SQL function like getdate() in
>TQuery component ?

>(2) I made stored procedure like following

>**********************************************************************
>create procedure sp_getdate

>as

>/*   getting server datetime  */

>declare  @serverdate datetime

>select @serverdate = getdate()

>select @serverdate

>GO

>GRANT  EXECUTE  ON dbo.sp_getdate  TO public
>GO
>**********************************************************************

>But this stored procedure doesn't work.

>How can I get server-side datetime ?
>Any advice will be appreciated.

Other Threads