`DATE` is a reserved keyword in Oracle, so I&#39;m using column-name `your_date` instead.

If you have an index on `your_date`, I would use

    WHERE your_date &gt;= TO_DATE(&#39;2010-08-03&#39;, &#39;YYYY-MM-DD&#39;)
      AND your_date &lt;  TO_DATE(&#39;2010-08-04&#39;, &#39;YYYY-MM-DD&#39;)

or `BETWEEN`:

    WHERE your_date BETWEEN TO_DATE(&#39;2010-08-03&#39;, &#39;YYYY-MM-DD&#39;)
                        AND TO_DATE(&#39;2010-08-03 23:59:59&#39;, &#39;YYYY-MM-DD HH24:MI:SS&#39;)

If there is no index or if there are not too many records

    WHERE TRUNC(your_date) = TO_DATE(&#39;2010-08-03&#39;, &#39;YYYY-MM-DD&#39;)

should be sufficient. [`TRUNC`][1] without parameter removes hours, minutes and seconds from a `DATE`.

---

If performance really matters, consider putting a [`Function Based Index`][2] on that column:

    CREATE INDEX trunc_date_idx ON t1(TRUNC(your_date));


  [1]: http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_functions_2127.htm
  [2]: http://www.akadia.com/services/ora_function_based_index_2.html

Convert your date column to the correct format and compare:
    
    SELECT * From my_table WHERE to_char(my_table.my_date_col,&#39;MM/dd/yyyy&#39;) = &#39;8/3/2010&#39;


This part

    to_char(my_table.my_date_col,&#39;MM/dd/yyyy&#39;)

Will result in string *&#39;8/3/2010&#39;*


Personally, I usually go with:

    select * 
    from   t1
    where  date between trunc( :somedate )          -- 00:00:00
                and     trunc( :somedate ) + .99999 -- 23:59:59

You could use the between function to get all records between 2010-08-03 00:00:00:000 AND 2010-08-03 23:59:59:000

`trunc(my_date,&#39;DD&#39;)` will give you just the date and not the time in Oracle.

Simply use this one:

```sql
select * from t1 where to_date(date_column)=&#39;8/3/2010&#39;
```

&gt; Try the following way.

    Select * from t1 where date(col_name)=&quot;8/3/2010&quot; 

When should you use `document.all` vs. `document.getElementById`?

document.all vs. document.getElementById

I&#39;m trying to use PHPMailer for a small project, but I&#39;m a bit confused about error handling with this software. Hoping someone has experience with it. When I&#39;ve set up an email and I use:

    $result = $mail-&gt;Send();
    
    if(!$result) {
        // There was an error
        // Do some error handling things here
    } else {
        echo &quot;Email successful&quot;;
    }

Which works fine, more or less. The problem is when there&#39;s an error, PHPMailer also seems to echo the error out, so if there&#39;s a problem, it just sends that info directly to the browser, essentially breaking any error handling I&quot;m trying to do.

Is there a way to silence these messages? Its not throwing an exception, its just printing out the error, which in my test case is:

    invalid address: @invalid@email You must provide at least one recipient email address.

Its meant to be an error, but it should be residing in $mail-&gt;ErrorInfo; not being echo&#39;d out by the software.

Error handling with PHPMailer

I&#39;m trying to retrieve records from table by knowing the date in column contains date and time.

Suppose I have table called `t1` which contains only two column `name` and `date` respectively.

The data stored in column date like this `8/3/2010 12:34:20 PM`.

I want to retrieve this record by this query for example (note I don&#39;t put the time):

    Select * From t1 Where date=&quot;8/3/2010&quot;

This query give me nothing ! 

How can I retrieve `date` by knowing only `date` without the time?

Select from table by knowing only date without time (ORACLE)

I'm trying to retrieve records from table by knowing the date in column contains date and time.
Suppose I have table called <code>t1</code> which contains only two column <code>name</code> and <code>date</code> respectively.
The data stored in column date like this <code>8/3/2010 12:34:20 PM</code>.
I want to retrieve this record by this query for example (note I don't put the time):
<pre><code class="hljs language-sql">Select * From t1 Where date="8/3/2010"
</code></pre>
This query give me nothing !
How can I retrieve <code>date</code> by knowing only <code>date</code> without the time?

I use an API that expects a SQL string. I take a user input, escape it and pass it along to the API.  The user input is quite simple. It asks for column values. Like so:

    string name = userInput.Value;

Then I construct a SQL query:

    string sql = string.Format(&quot;SELECT * FROM SOME_TABLE WHERE Name = &#39;{0}&#39;&quot;,
                               name.replace(&quot;&#39;&quot;, &quot;&#39;&#39;&quot;));

Is this safe enough? If it isn&#39;t, is there a simple library function that make column values safe:

    string sql = string.Format(&quot;SELECT * FROM SOME_TABLE WHERE Name = &#39;{0}&#39;&quot;,
                               SqlSafeColumnValue(name));


The API uses SQLServer as the database. 


How to escape simple SQL queries in C# for SqlServer

Before moving to PDO, I created SQL queries in PHP by concatenating strings. If I got database syntax error, I could just echo the final SQL query string, try it myself on the database, and tweak it until I fixed the error, then put that back into the code.

Prepared PDO statements are faster and better and safer, but one thing bothers me: I never see the final query as it&#39;s sent to the database. When I get errors about the syntax in my Apache log or my custom log file (I log errors inside a `catch` block), I can&#39;t see the query that caused them.

**Is there a way capture the complete SQL query sent by PDO to the database and log it to a file?**

How to debug PDO database queries?

I have a table that is a collection entries as to when a user was logged on.

    username, date,      value
    --------------------------
    brad,     1/2/2010,  1.1
    fred,     1/3/2010,  1.0
    bob,      8/4/2009,  1.5
    brad,     2/2/2010,  1.2
    fred,     12/2/2009, 1.3

    etc..

How do I create a query that would give me the latest date for each user?

**Update:** I forgot that I needed to have a value that goes along with the latest date.

how do I query sql for a latest record date for each user

I have a SQLite database that I am trying to sort by Alphabetical order.  The problem is, SQLite doesn&#39;t seem to consider A=a during sorting, thus I get results like this:

A
B
C
T
a
b
c
g

I want to get:

A
a
b
B
C
c
g
T

What special SQL thing needs to be done that I don&#39;t know about?

    SELECT * FROM NOTES ORDER BY title




How to use SQL Order By statement to sort results case insensitive?

I need to write a query on SQL server to get the list of columns in a particular table, its associated data types (with length) and if they are not null. And I have managed to do this much. 

But now i also need to get, in the same table, against a column - `TRUE` if that column is a primary key. 

How do i do this? 

My expected output is:

```
Column name | Data type | Length | isnull | Pk
```

SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints

I have a query which works fine in MySQL, but when I run it on Oracle I get the following error:

&gt; SQL Error: ORA-00933: SQL command not properly ended&lt;br/&gt;
&gt; 00933. 00000 -  &quot;SQL command not properly ended&quot;

The query is:

    UPDATE table1
    INNER JOIN table2 ON table1.value = table2.DESC
    SET table1.value = table2.CODE
    WHERE table1.UPDATETYPE=&#39;blah&#39;;

Update statement with inner join on Oracle

I have an big problem with an SQL Statement in Oracle. I want to select the TOP 10 Records ordered by STORAGE_DB which aren&#39;t in a list from an other select statement.

This one works fine for all records:

    SELECT DISTINCT 
      APP_ID, 
      NAME, 
      STORAGE_GB, 
      HISTORY_CREATED, 
      TO_CHAR(HISTORY_DATE, &#39;DD.MM.YYYY&#39;) AS HISTORY_DATE  
      FROM HISTORY WHERE 
          STORAGE_GB IS NOT NULL AND 
            APP_ID NOT IN (SELECT APP_ID
                           FROM HISTORY
                            WHERE TO_CHAR(HISTORY_DATE, &#39;DD.MM.YYYY&#39;) = &#39;06.02.2009&#39;) 
            
But when I am adding 

    AND ROWNUM &lt;= 10
    ORDER BY STORAGE_GB DESC

I&#39;m getting some kind of &quot;random&quot; Records. I think because the limit takes in place before the order.

Does someone has an good solution? The other problem: This query is realy slow (10k+ records)


Oracle SELECT TOP 10 records

I have a database which has a NOT NULL constraint on a field, and I want to remove this constraint.  The complicating factor is that this constraint has a system-defined name, and that constraint&#39;s name differs between the production server, integration server, and the various developer databases.  Our current process is to check in change scripts, and an automated task executes the appropriate queries through sqlplus against the target database, so I&#39;d prefer a solution that could just be sent straight into sqlplus.

On my own database, the SQL to drop this would be:

    alter table MYTABLE drop constraint SYS_C0044566

I can see the constraint when I query the `all_constraints` view:

    select * from all_constraints where table_name = &#39;MYTABLE&#39;

but I am not sure how to work with the `SEARCH_CONDITION`&#39;s `LONG` data type or how best to dynamically delete the looked-up constraint even after I know its name.

So, how can I create a change script that can drop this constraint based on what it is, rather than what its name is?

----
EDIT:
@Allan&#39;s answer is a good one, but I am concerned (in my lack of Oracle expertise) that it may not be universally true that any constraint that might have a system-generated name will have associated with it a way to remove the constraint without having to know its name.  Is it true that there will always be a way to avoid having to know a system-named constraint&#39;s name when logically dropping that constraint?

How can I drop a &quot;not null&quot; constraint in Oracle when I don&#39;t know the name of the constraint?

How to export Oracle DB data using SQL Developer? I need all data, tables, constraints, structure and so on.

How to export data with Oracle SQL Developer?

I would like to create a temporary table in a Oracle database

something like 

    Declare table @table (int id)

In SQL server

And then populate it with a select statement

Is it possible?

Thanks

How do you create a temporary table in an Oracle database?

I have a year value and a day of year and would like to convert to a date (day/month/year).

How to convert Year and Day of Year to Date?

Is there a Java package with all the annoying time constants like
milliseconds/seconds/minutes in a minute/hour/day/year? I&#39;d hate to duplicate something like that.

Time consts in Java?

I need to round times down to the nearest quarter hour in PHP.  The times are being pulled from a MySQL database from a datetime column and formatted like `2010-03-18 10:50:00`.

Example:

- 10:50 needs to be 10:45
- 1:12 needs to be 1:00
- 3:28 needs to be 3:15
- etc.

I&#39;m assuming `floor()` is involved but not sure how to go about it.

Thanks


Round minute down to nearest quarter hour

I am trying to convert a date from `yyyy-mm-dd` to `dd-mm-yyyy` (but not in SQL); however I don&#39;t know how the date function requires a timestamp, and I can&#39;t get a timestamp from this string.

How is this possible?


Convert a date format in PHP

I need to get the number of days contained within a couple of dates on MySQL. 

For example: 

* Check in date is `12-04-2010`   
* Check out date `15-04-2010`

The day difference would be 3.



Content Type	Original Author	Original Content on Stackoverflow
Question	Abdulrhman	View Question on Stackoverflow
Solution 1 - Sql	Peter Lang	View Answer on Stackoverflow
Solution 2 - Sql	JavaSheriff	View Answer on Stackoverflow
Solution 3 - Sql	R. Genaro	View Answer on Stackoverflow
Solution 4 - Sql	Dustin Laine	View Answer on Stackoverflow
Solution 5 - Sql	Dave Kuziara	View Answer on Stackoverflow
Solution 6 - Sql	Oragon	View Answer on Stackoverflow
Solution 7 - Sql	kiruthika	View Answer on Stackoverflow

Select from table by knowing only date without time (ORACLE)

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

Solution 5 - Sql

Solution 6 - Sql

Solution 7 - Sql

Error handling with PHPMailer

document.all vs. document.getElementById

Attributions