pgsql sql中获取当前时间_获取PostgreSQL查询的执行时间

DECLARE @StartTime datetime,@EndTime datetime

SELECT @StartTime=GETDATE()

select distinct born_on.name

from born_on,died_on

where (FLOOR(('2012-01-30'-born_on.DOB)/365.25) <= (

select max(FLOOR((died_on.DOD - born_on.DOB)/365.25))

from died_on, born_on

where (died_on.name=born_on.name))

)

and (born_on.name <> All(select name from died_on))

SELECT @EndTime=GETDATE()

SELECT DATEDIFF(ms,@StartTime,@EndTime) AS [Duration in millisecs]

我无法获取查询时间.相反,我得到以下错误：

sql:/home/an/Desktop/dbms/query.sql:9: ERROR: syntax error at or near "@"

LINE 1: DECLARE @StartTime datetime,@EndTime datetime