Hi
I am using &DATEtMDYY for current date in Report Header. It is giving Jan25,2010. But i need a format like this: 11/10/2009 11:17am. i.e Timestamp.Any help would be appreciated. HTML output,report painter,DB2 stored procedure.
thanks,
rama

This message has been edited. Last edited by: Kerry,

This:

-TYPE &DATEMDYY &TOD

gives you this:

01/15/2010 11.44.09

You can parse &TOD to add the am or the pm.

You may also try:

-SET &CURRDTTM = HCNVRT(HGETC(10, 'HYYMDSA'), '(HMDYYSA)', 25, 'A25');
-TYPE &CURRDTTM

Which will give you:

01/15/2010 12:48:07PM

Neftali.

Ginny,
That is a real and timely help. Thank you so much.
rama

Hi Neftali,
Yours is fantastic.
thanks for the help,
rama

One step beyond that, add the following to get

01/19/2010  8:48am

-SET &CURRDTTM = EDIT(&CURRDTTM,'9999999999999999$$$99') ;
-SET &CURRDTTM = LOCASE(18,'&CURRDTTM.EVAL',&CURRDTTM) ;

I showed this in two steps (EDIT and LOCASE) for simplicity. Combine them as desired...

With a small modification, you will get the same effect on a single line of code by changing the code to read:

quote:

-SET &CURRDTTM = HCNVRT(HGETC(10, 'HYYMD'), '(HMDYYIa)', 25, 'A25');
-TYPE &CURRDTTM

displays as:

01/20/2010 8:20am

And for fancier kicks, another small change

quote:

-SET &CURRDTTM = HCNVRT(HGETC(10, 'HYYMD'), '(HMTDYYIa)', 25, 'A25');
-TYPE &CURRDTTM

will get you:

January 20 2010 8:24am

Hi Dav smith,
Thanks for the reply. I need to display 01/20/2010 in line one and timestamp 8.24AM is on second line.i.e at two different places.How can i do it with your code.Thanks for a kind help,
rama

You're kidding right? The output from Dav's suggestion is a single alphanumeric (A25) variable it should be quite easy to work out how to split it into two variables from one.

T