CIVTIME

Pass it the military time from a time stamp field and it returns the standard time.

Reporting Area(s)

Registrations, Accounting

Required Parameters

1. TimeField (i.e. Cocrsetm,Nmuptm,Pyuptm,Rgupdttm)

--OR-- Character String in Time Format (i.e. "13:30:01").

Optional Parameters

None

Example(s)

CIVTIME(rgupdttm) returns 1:30 p.m. where rgupddttm = 13:30:01

Related Functions

ADDTIME
NICETIME
TIME
GETCIV