Timestamp Format

[major]

Hi all,

I need timestamp in below format

Code: Select all

MM/DD/YYYY HH:MM:SS AM/PM

Currently I am using below function

Code: Select all

OCONV(DATE(),"D/MDY[2,2,4]") :" " : UPCASE(OCONV(TIME(),"MTHS"))

Is there any better way to do it as the function I'm using is appending seconds with AM/PM

Eg:-01/01/2010 12:12:12AM --> 01/01/2010 12:12:12 AM

Thanks

[ray.wurlod]

Lose the "H" from the time conversion, which specifies a 12-hour clock. No "H" specifies a 24-hour clock.

Code: Select all

OCONV(DATE(),"D/MDY[2,2,4]") :" " : OCONV(TIME(),"MTS")

[major]

Ray,

Actually I need a 12 hour clock with AM/PM

Thanks,

[chulett]

Which is what you have, so you're good there. The issue is the fact that there's no space in front of the AM/PM, not sure why it wants to run the two together but it does. As far as I know, you need to split the result and insert the space yourself, which is easy since the output is a fixed size.

[ray.wurlod]

Ah. I misunderstood. As noted, take the left 19 characters, a space and the right two characters. Use a stage variable to avoid calculating the timestamp twice.

Code: Select all

svTimestamp  <--  Oconv(Date(),"D/MDY[2,2,4]" : " " : Upcase(Oconv(Time(),"MTHS"))

Left(svTimestamp,19) : " " : Right(svTimestamp.2)

[major]

Thanks guys.. :D