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://www.blackholesurfer.com/phpBB3/
http://www.blackholesurfer.com/phpBB3/viewtopic.php?f=24&t=116
Code: Select all
SELECT * from table where
last_seen <= CONVERT(DATETIME,GETDATE()) and last_seen >= CONVERT(DATETIME,'2023-09-02 17:38:10'