0

I have a Oracle DB in which the time is stored in UNIX time format. Currently I write queries having UNIX time format. for example.

(TIME >= '1648771200' and TIME <= '1651320000')

I want the query to be user friendly having conventional date format,

(TIME >= '2022-05-10 12:00:00' and TIME <= '2022-05-20 12:00:00')

Is it possible to do it ? Thank you.

Barbaros Özhan
  • 47,993
  • 9
  • 26
  • 51
Nikola
  • 1

0 Answers0