In many cases it is beneficial to combine date and time values into one field. To do this in OpenGate you would use the following format:
{(@NprDateField,@NprTimeField)} as [DateTimeValue]
OutPut value will be:
“YYYYMMDD HHMM”
Ex:
Select
ADM.PAT.admit.date,
ADM.PAT.admit.time,
{(@ADM.PAT.admit.date,@ADM.PAT.admit.time)} as [AdmitDateTime]
from ADM.PAT.main
or
{@RAD.RES.service.date,@RAD.RES.service.time)} as [ServiceDateTime]
The output value will look like:
“20121231 1234”
“20121231 1234”