Hi Thanx..one more help.
I am creating a function that will retuen the current systemdate.
CREATE FUNCTION "CreateDate"() RETURNS date AS
'select now();'
LANGUAGE 'plpgsql';
However, I get the error:
ERROR: syntax error at or near "select" at character 51
Any suggestions .??
Thanks in advance
select CURRENT_TIMESTAMP
or
select LOCALTIMESTAMP
the first has the information with the timezone offset at the end, whereas the second does not.
Hi,
How to check the system date using PG/SQL ??