Re: Need help formatting a timestamp to long character

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