Re: Formatting current_time output

On Thu, 3 Oct 2002, Josh Berkus wrote:

> Thomas,
>
> > SELECT TO_CHAR(SYSDATE,'HH:MI AM') FROM DUAL; -- Oracle
> > SELECT TIME_FORMAT(current_time,'%l:%i %p');  -- MySQL
> >
> > Returned:   10:58 AM
> >
> > I've found lpad(current_time,5); which gets me 1/3 of the way.
> > Is there a function I haven't found?
>
> Um, what's wrong with:
> SELECT to_char(current_time, 'HH12:MI AM');

Not a thing!  Except that I think you mean 'current_date'.  ;-)

Cheers Josh (and thanks alot)...

BTW the JOIN you sent the other day worked fine.
Thanks again,
-----------------------------------------------------------------------
Thomas Good                                  e-mail: tomg@sqlclinic.net
Programmer/Analyst                           phone:   (+1) 718.818.5528
Residential Services                         fax:     (+1) 718.818.5056
Behavioral Health Services, SVCMC-NY         mobile:  (+1) 917.282.7359
--                                                                   --
SQL Clinic - An Open Source Clinical Record           www.sqlclinic.net
------------------------------------------------------------------------