Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bP48P-0003jI-QH for pgadmin-hackers@arkaria.postgresql.org; Mon, 18 Jul 2016 08:42:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bP48P-0005yN-DJ for pgadmin-hackers@arkaria.postgresql.org; Mon, 18 Jul 2016 08:42:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bP48C-0005kY-Rs for pgadmin-hackers@postgresql.org; Mon, 18 Jul 2016 08:42:28 +0000 Received: from mail-it0-x22e.google.com ([2607:f8b0:4001:c0b::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bP489-0001XB-CB for pgadmin-hackers@postgresql.org; Mon, 18 Jul 2016 08:42:28 +0000 Received: by mail-it0-x22e.google.com with SMTP id f6so67833729ith.0 for ; Mon, 18 Jul 2016 01:42:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=1K9JH/JVUGJAjguWX1MycU8R+vcssaWAB9jex6ebd8E=; b=vq1BefdyNuPzuuDoDRZNz4rvVXQfp2PtINd2bkVY4hfGBUeoc7uAF9p033y9j/+xgU BTrpskFoQJInjDc9xV15XwCeoq7EGSP+fRZufUR0MNMTJZjyLOG2rD3zbZem3pdNB9jT 5LHlh7A5gQk+BoM5LXcIyP1twfJMatGI1rzvkpjqE0nhoPSai/BO4XXkEbUCgBV/luss sqnGy4o988MChCK+GH5cjAb+Eo6XChO7+mxwEF7ow6OLzM104TEZhc/wUcLwki9uC9Zz AubIycn10sLNLL1h3DGpk/Xa1rWJ9wLEazZU1Up21Tv0oZFNm1XpCqPb1vaMjVAKeoc5 ToAw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=1K9JH/JVUGJAjguWX1MycU8R+vcssaWAB9jex6ebd8E=; b=mNWAR/aHc9arwky2hpipdEtKVd3iwaFtwoHTCQh3QSeSz980fSNIyY3GRl+oRuFiLW JLLR9hyswiqvlQwT1GSDQ8Ah0nkLbLpnT9Tpuk80qWLHVLTZ4g4iK9Sj0cVg/kcm1U5I eIDYVdFUVs6V8RVd5FosBY7GynuPyn1zxDxOe9+bCCaXO+CErWUonW/uYCgzB4EKd5aa kZ5GbZAYTFRKe1X4mhWKkHgisecOolWj4wzF/KY8MEnKjusGeIserznDEO4oLoIL4RA2 vN8nNHxt4LxSGO0yyzL86qTZRzkuqFvIxqQNb3Es+rlJ9fGlo3MPq3h7s097+NxF3Qan XrQQ== X-Gm-Message-State: ALyK8tL3XweV7m9DirdDOXvEyCY1RXCaXJ6ZLAF1zZzNme42Z3WwVu26e5uKOkc01CGOTJ8rZZEHiFf4bsGuMA== X-Received: by 10.36.103.4 with SMTP id u4mr47065457itc.88.1468831343632; Mon, 18 Jul 2016 01:42:23 -0700 (PDT) MIME-Version: 1.0 Received: by 10.64.208.97 with HTTP; Mon, 18 Jul 2016 01:42:23 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Mon, 18 Jul 2016 09:42:23 +0100 Message-ID: Subject: Re: PATCH: To fix Timestamps displaying with time as 00:00 (pgAdmin4) To: Murtuza Zabuawala Cc: pgadmin-hackers Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org Thanks - applied. On Mon, Jul 18, 2016 at 7:34 AM, Murtuza Zabuawala wrote: > Hi Dave, > > Please find patch to fix the issue for interval type casting. > > > Regards, > Murtuza > > -- > Regards, > Murtuza Zabuawala > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > On Fri, Jul 15, 2016 at 4:31 PM, Dave Page wrote: >> >> Hi >> >> On Thu, Jul 14, 2016 at 7:00 AM, Murtuza Zabuawala >> wrote: >> > Hi, >> > >> > PFA patch to fix the issue in timestamp datatype(s) displaying with time >> > as >> > 00:00 >> > (RM#1437) >> > >> > The issue was with backgrid datetime cell which do not fully support >> > ISO-8601 datetime format. >> >> Thanks - this worked, except for the 'interval' type, I've committed >> the patch without that change; please submit another fixing that >> remaining issue. >> >> e.g. select '1 month'::interval >> >> displays: 00:00:00 >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers