Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

to_char with time


  • From: chester c young <chestercyoung(at)yahoo(dot)com>
  • To: pgsql-sql(at)postgresql(dot)org
  • Subject: to_char with time
  • Date: Tue, 13 Jun 2006 21:09:34 -0700 (PDT)
  • Message-id: <20060614040934(dot)1411(dot)qmail(at)web54313(dot)mail(dot)yahoo(dot)com>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group