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
________________________________ From: Benjamin Krajmalnik [mailto:[EMAIL PROTECTED] Sent: Thursday, January 18, 2007 5:31 PM To: Negandhi, Nishith; [email protected] Subject: RE: [ADMIN] System Date select CURRENT_TIMESTAMP or select LOCALTIMESTAMP the first has the information with the timezone offset at the end, whereas the second does not. ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Negandhi, Nishith Sent: Thursday, January 18, 2007 3:43 PM To: [email protected] Subject: [ADMIN] System Date Hi, How to check the system date using PG/SQL ??
