ABAP SUBSTRING IN SQL

[Former Member]

Hi,

I have a SQL where I want to extract only the people that the birthdate is for today. The field format is 2008/04/18 and I want to only extract on 18/4 all the people that were born on that day. eg 1944/04/18 or 1967/04/18.

thanks

[Former Member · Accepted solution]

Assuming the Oracle data type of your field is varchar2:

select whatever from table

where substr(field,6) = to_char(sysdate,'MM/DD')

hope this helps

Edited by: Joe Bo. on Apr 3, 2008 2:51 PM