time stamp concatenation

scottr · Post by **scottr** » Thu Feb 03, 2005 2:52 pm

friends i have 4 fields as HR,MIN,SEC,AM_PM_Flag.

how to concate these fields to get time stamp like HR:MIN:SECAM_PM_FLAG. i tried with the regular : but all i got is HRMINSECAM_PM_FLAG.

thanks for ur help

kcbland · Post by **kcbland** » Thu Feb 03, 2005 2:57 pm

Code: Select all

linkname.HR:linkname.MIN:linkname.SEC:linkname.AM_PM_Flag

scottr · Post by **scottr** » Thu Feb 03, 2005 3:03 pm

Ken, the output came like 02025AM ,but i want it like 02:02:5AM

thanks

ray.wurlod · Post by **ray.wurlod** » Thu Feb 03, 2005 3:05 pm

If you want delimiters, you have to concatenate them in, too.

Code: Select all

HR : ":" : MIN : ":" : SEC : " " : AM_PM_Flag

Or, if you can be certain that each component is two characters long, you can concatenate first and format later.

Code: Select all

Fmt(HR:MIN:SEC:AM_PM_Flag, "R##:##:## ##")

scottr · Post by **scottr** » Thu Feb 03, 2005 3:10 pm

Thanks Ray...