Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

concatenate a date field with other fields

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • concatenate a date field with other fields

    I use the %char bif to create a "character" version of a date field. Example: Run = 'OPNQRYF FILE((COVMST)) + QRYSLT(''ISSUE *GE "' + %Char(Cutoff) + '"'')'. I know you could result into a character field. Let me know if this help you with the select statement. I have struggled with sql concats in the past.

  • #2
    concatenate a date field with other fields

    I am trying to display information on my screen using SQL. The statement reads: SELECT field1 || field2 || datefield from mylib/filea. I get an error message. field1 and field2 are character fields and datefield is an *ISO Date field. Is it possible to concatenate a Date field with other fields? Or how can I change the Date field to a character field? Thank You.

    Comment


    • #3
      concatenate a date field with other fields

      bentley, Thank you. The char() word is what I found out that I needed. It works fine.

      Comment

      Working...
      X