Oracle data conversion queries
Posted: Fri Sep 22, 2023 1:42 pm
Code: Select all
SELECT * from table where
last_seen <= CONVERT(DATETIME,GETDATE()) and last_seen >= CONVERT(DATETIME,'2023-09-02 17:38:10'CMDB professionals helping clients to skate the event horizon of a black hole (where your data disappears). Keeping you ahead of the game.
http://blackholesurfer.com/phpBB3/
Code: Select all
SELECT * from table where
last_seen <= CONVERT(DATETIME,GETDATE()) and last_seen >= CONVERT(DATETIME,'2023-09-02 17:38:10'