Fetching records from TableA where the record_create_ date is greater than Jan 01 2018. Record_Create_Date is a numeric field(8 S 0)

Select * From TableA where Date (Digits (Record_create_date) || ‘000000’ ) >= ’01/01/2018′

The DIGITS function returns a character string representation of the absolute value of a number