Concatenating data and time fields in OpenGate

Home/Support/OpenGate/Concatenating data and time fields in OpenGate

Home Forums Support OpenGate Concatenating data and time fields in OpenGate

Viewing 1 post (of 1 total)
  • Author
    Posts
  • Shawn Kenny
    Keymaster
    Post count: 27

    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”

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Blue Elm Eventts

December 2018
S M T W T F S
« Aug    
 1
2345678
9101112131415
16171819202122
23242526272829
3031