Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to load part of date (for 24/03/01), but in Oracle Sql Base data form is timestamp.
How can I succesffuly obtain it? How can I change date form after sql's 'where'?
for Oracle db try
SELECT * FROM table
WHERE TRUNC(column) = TO_DATE('24-03-2001', 'DD-MM-YYYY')
for Oracle db try
SELECT * FROM table
WHERE TRUNC(column) = TO_DATE('24-03-2001', 'DD-MM-YYYY')