How to filter data timpe stamp via select in sql?

[Asiolinka]

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'?

[maxgro · Accepted solution]

for Oracle db try

SELECT * FROM table
WHERE TRUNC(column) = TO_DATE('24-03-2001', 'DD-MM-YYYY')