I have a field which stores the date in a Unix timestamp.

Instead of having to translate the test ie

```
TO_DATE( TO_CHAR( TO_DATE('19700101', 'yyyymmdd') + + ( FLOOR( ph.change_date / 24 / 60 / 60)))) = '07-NOV-2020'

```

I want to just say

```
ph.change_date = Todays Date  

```

But have that as a Unix Timestamp.

Any help appreciated.