SELECT with Sysdate and format Timestamp
Hello,
I am Junior in Oracle and I have a problem. I need to write a Query to get rows with function SYSDATE but date in my database is timestamp(1510614000) but DATA_TYPE is as Number. I dont know how to write this select, I would like something like that:
SELECT * FROM user.Table WHERE DATE > sysdate- 7 days
I tried this but didnt work : select * from User.clientes where DATE > TO_NUMBER(TO_CHAR(sysdate - 3, '')*86400);
My database is something like that:
COLUM_NAME DATA_TYPE EXAMPLE
------------------ ---------------- ---------------
ID_CLIENT NUMBER 1
NAME VARCHAR CHARLEY
DATE NUMBER 1510614000
1510614000= 14/11/2017 0:00:00
I appreciate help, please.