Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bO0s3-00067D-Fm for pgadmin-hackers@arkaria.postgresql.org; Fri, 15 Jul 2016 11:01:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bO0s3-0002Ve-39 for pgadmin-hackers@arkaria.postgresql.org; Fri, 15 Jul 2016 11:01:27 +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 1bO0rq-0002G6-B0 for pgadmin-hackers@postgresql.org; Fri, 15 Jul 2016 11:01:14 +0000 Received: from mail-it0-x22a.google.com ([2607:f8b0:4001:c0b::22a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bO0rm-0007QT-JU for pgadmin-hackers@postgresql.org; Fri, 15 Jul 2016 11:01:13 +0000 Received: by mail-it0-x22a.google.com with SMTP id f6so16027678ith.0 for ; Fri, 15 Jul 2016 04:01:09 -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=wyQzopgJuDv71rIV3vyKEfJvIkQFcY9ggWSJ7ePSvok=; b=l2KO2Ln8MK1F8F4QdCAErJnj+P9MuBZMf9H7cyZ4cQPvdoDImixVr1QO4ilIdj5zmO mjXPJ94dRc2ibhPxzdQTOvcMfnVJMDbXdtRdkxQeUGpPGtO+JQZJtjY7MzXSE1AmbnS3 jqX/jt/9CF9I8BWQCt9GxKncFxCktcXipCcxz9QsRQDoll262Xpi+eDlIryGmlhRr+D4 1sBAH66HIzpZcKZsdsNzbrYK6bN43SNgso6jODzWpSE8/U1u5QWfEUP+erTK9HnZBrju fr/BG1jCKnMx/dkmXzmG1qhl1n7A8vgtp5ZbYwtroBpT5T9JbxzqykL7yIgVQT3Quoml 2/HA== 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=wyQzopgJuDv71rIV3vyKEfJvIkQFcY9ggWSJ7ePSvok=; b=kQvw/wrNrTWMEMtYQCpEzSM0ZgCoPUig0s1QjqsUCGPgJlZr3rf+xtkiOOmVxGXlx/ hCH9cBdtvaGzsrwNm9tfB5M07oa/RBVZEdhpf/QHMCKFPiR7UPjZ+6CAJlbDhWQXbuh6 JwlZaF03y/BtJE2FPPQpkl3keY8kZvCh0d4qdATBN8B3pgCSntw+tJKlg9oJsXJcvR25 rntf3nODdYKTYXyBxU99FYlVHt/MTURrA1aufICFo5R8ytf9/72KzQCm5YmEaNpqfN73 A/s5iX3dTgX94aB34sq7G/a0DdNCoCnjFk7UAQukJOYkVOqpQ9D1isfQhufPW2anpbh5 PhKw== X-Gm-Message-State: ALyK8tIDtX6wlygkeVMPgK8wjIapLyZH9mS2voblBfY8j64TmvuIxr87nUI0gWm0u30Yek/EE4MFa9lROZy4iw== X-Received: by 10.36.117.79 with SMTP id y76mr27581153itc.35.1468580468202; Fri, 15 Jul 2016 04:01:08 -0700 (PDT) MIME-Version: 1.0 Received: by 10.64.208.97 with HTTP; Fri, 15 Jul 2016 04:01:07 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Fri, 15 Jul 2016 12:01:07 +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 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 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers