No getdate() function in Enterprise PostgreSQL

Question

Hi guys, do you have any idea on how to have getdate() function in enterprise postgresql? I upgraded to EDB-PSQL, and now when I tried to restore old data from the free PSQL, it returns error on some tables since there is no getdate(). I believe this should automatically be created upon creating new database? But it didn't. :( Only now() function. Can I create the function instead? Help!

Answer 1

If getdate() is like now() (as with SQL Server) you can simply say

create function public.getdate() returns timestamptz
       stable language sql as 'select now()';