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: 26

    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

October 2019
S M T W T F S
« Aug    
 12345
6789101112
13141516171819
20212223242526
2728293031