Search code examples
postgresqlenterprisedb

No getdate() function in EnterpriseDB PostgreSQL

Do you have any idea on how to have a getdate() function in EnterpriseDB PostgreSQL? I upgraded to EDB-PSQL, and when I try 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 a now() function.

Can I create the function instead? Help!

Solution

  • 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()';