Search code examples
datetypesproc-sql

Insert date into date9

Within my PROC SQL snipped I am trying to compare a column of datatype date9. to the date 31.12.2015'. I tried:

test_date = '31DEC2015'

This returns me the following error:

ERROR: Expression using equals (=) has components that are of different data types.

What would be the correct syntax?

Solution

  • Add "d" to the end of the quoted date value:

    test_date = '31DEC2015'd;