X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E48219FA692 for ; Wed, 14 Jun 2006 01:09:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 88753-07 for ; Wed, 14 Jun 2006 01:09:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web54313.mail.yahoo.com (web54313.mail.yahoo.com [206.190.49.123]) by postgresql.org (Postfix) with SMTP id C34029FA68D for ; Wed, 14 Jun 2006 01:09:35 -0300 (ADT) Received: (qmail 1413 invoked by uid 60001); 14 Jun 2006 04:09:34 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=hloAF3omIRYES6HALuaKaup9ThHToLnucqQp9W/o3mt8xBhiP6zIUQWcean+LDhCkMkLjxKkLsEnOQmC+yh9JsIhoyFs45Mf11Q6mYRvE7iWRfhmaV1+ECSbBHC+bHgTd7I927OjFSF1A5aCdKRFmxp4qQXo6HHGQvOenzIATAM= ; Message-ID: <20060614040934.1411.qmail@web54313.mail.yahoo.com> Received: from [68.35.2.64] by web54313.mail.yahoo.com via HTTP; Tue, 13 Jun 2006 21:09:34 PDT Date: Tue, 13 Jun 2006 21:09:34 -0700 (PDT) From: chester c young Subject: to_char with time To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1378802324-1150258174=:94724" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.4 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_WHOIS, HTML_10_20, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200606/148 X-Sequence-Number: 25384 --0-1378802324-1150258174=:94724 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit this does not work: select to_char(current_time,'HH24:MI') what am I missing? is it possible to format a time column in a select? thanks, stumped, aka, chester __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-1378802324-1150258174=:94724 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit this does not work: select to_char(current_time,'HH24:MI')

what am I missing?  is it possible to format a time column in a select?

thanks,
stumped, aka, chester

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com --0-1378802324-1150258174=:94724--