Re: Need help formatting a timestamp to long character

[Paul Jackson <paulgjackson@xxxxxxxxx>]

On Thu, Apr 8, 2010 at 11:20 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:
> Paul Jackson wrote:
> > I need to convert a 26 character system timestamp (Z type) to a
> > string that goes something like: "nn:nn AM/PM, Day name, Month
> > name DD, YYYY".
> >
> > At first I saw the CEEDATE API and got excited as it seemed to be
> > able to output that format precisely and then noticed that it
> > cannot take a time as input, only Lilian days (which makes me
> > wonder why it allows you to specify the time symbols on the input
> > picture string).
> >
> > Anyway it looks like I can use CEEDATE to get the date part
> > formatted and then manually do the time section.
> >
> > Just wondering if anyone has a better solution or suggestion,
> > don't want to reinvent the wheel as I'm sure this has been done
> > elsewhere.

Thanks everyone for your responses. The SQL solution looks intriguing,
and thankyou Scott for pointing me to the correct API's and for
providing an example (which always helps a lot IMHO) If only I'd
looked a couple of lines down in the CEE date/time page :-)

-Paul