Postgres Pro
Downloads
Home   >   mailing lists

Re: Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1) - Mailing list pgsql-general

From John R Pierce
Subject Re: Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1)
Date
Msg-id 51CC8A2F.40906@hogranch.com
Whole thread Raw
In response to Re: Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1)  (sachin kotwal <kotsachin@gmail.com>)
List pgsql-general
Tree view 
On 6/27/2013 4:51 AM, sachin kotwal wrote:
> #select timestamp(current_date);

try...   current_date::timestamptz
or....    cast current_date as timestamptz


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: installer woes, 9.1 on windows 2008 R2
Next
From: Sergey Konoplev
Date:
Subject: Re: Triggers NOT running as table owner