oracle SQL how to remove time from date

by

You can use TRUNC on DateTime to remove Time part of the DateTime. So your where clause can be: 

AND TRUNC(p1.PA_VALUE) >= TO_DATE('25/10/2012', 'DD/MM/YYYY')

The TRUNCATE (datetime) function returns date with the time portion of
the day truncated to the unit specified by the format model.

More Related Contents:

  1. How do I limit the number of rows returned by an Oracle query after ordering?
  2. How to create id with AUTO_INCREMENT on Oracle?
  3. When do I need to use a semicolon vs a slash in Oracle SQL?
  4. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  5. How to handle a single quote in Oracle SQL
  6. Select count(*) from multiple tables
  7. Fetch the rows which have the Max value for a column for each distinct value of another column
  8. REGEX to select nth value from a list, allowing for nulls
  9. Concatenate and group multiple rows in Oracle [duplicate]
  10. Difference between BYTE and CHAR in column datatypes
  11. Call a stored procedure with another in Oracle
  12. create table with sequence.nextval in oracle [duplicate]
  13. Oracle: loading a large xml file?
  14. IF EXISTS condition not working with PLSQL
  15. Group by alias (Oracle)
  16. Using pivot on multiple columns of an Oracle row
  17. Sleep function in ORACLE
  18. Split comma separated values of a column in row, through Oracle SQL query
  19. oracle — Split multiple comma separated values in oracle table to multiple rows
  20. How to query a CLOB column in Oracle
  21. update columns values with column of another table based on condition [duplicate]
  22. how to select even records from a table in oracle?
  23. Oracle : select maximum value from different columns of the same row
  24. Split varchar into separate columns in Oracle
  25. Creating or simulating two dimensional arrays in PL/SQL
  26. Connecting to Oracle Database using Sql Server Integration Services
  27. Retrieve Oracle last inserted IDENTITY
  28. ORA-00933: SQL command not properly ended
  29. Update a table with data from another table
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment