如何获取Interbase服务器的系统日期及时间？想用存过程，该如何写？(100分)

Z

zl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-07

• #1

如何获取Interbase服务器的系统日期及时间？想用存过程，该如何写？

 

P

Pipi.

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-07

• #2

cast("now" as date)
(不知道ib的日期类型是date还是datetime还是time，如果不是date，换成真的类型就可以了)

 

云

云飞

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-07

• #3

CREATE PROCEDURE "GET_SERVER_DATE" RETURNS(SERVER_DATE DATE)
AS
begin
server_date = cast ('now' as date);
end

 

K

K

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-07

• #4

关注

 

Z

zl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-07

• #5

接受答案了.