date between

Hi Iâ�?��?�ve wrote a program by Delphi 7, Iâ�?��?�ve used an Access database and SQL, and also in my tables I have some fields. One of my fields is date_, and the type of the field is DateTime. When I want to select records between 2 dates, I use this query:

Select * from table1 Where date_ between #01/01/2010# and #31/12/2010#

But it shows me the dates that are not in this query! Why?

View Answers

February 17, 2011 at 11:42 AM

SQL Query to display record between two dates:

SELECT * FROM emp WHERE JOINING_DATE BETWEEN '2000-01-01' AND '2010-01-01' ;

For the above query, here is the database table.

CREATE TABLE `emp` (                                     
          `EMP_NO` int(10) NOT NULL auto_increment,              
          `EMP_NAME` varchar(100) default NULL,                  
          `DESIGNATION` varchar(100) default NULL,               
          `JOINING_DATE` date default NULL,                      
          `SALARY` int(100) default NULL,                        
          `DEPT_NO` int(100) default NULL,                       
          PRIMARY KEY  (`EMP_NO`)                                
        );

February 20, 2011 at 10:47 AM

Thanks, because of your attention.

But unfortunately this is not the correct answer to my question.

I've found where my mistake was. I should change my date format to â�?��?yyyy-mm-ddâ�?��? and then I can got the correct query result.

Ads

Advertisements

SQL Between Date
SQL Between Date The Tutorial help you to understand SQL Between Date. In this Tutorial..._Table (Stu_Id varchar(2), Stu_Name varchar(15), Stu_Dob date); Insert Data

Hibernate criteria date between Example
Hibernate criteria date between Example Hibernate criteria date between Example I want example of hibernate criteria date between with source code... between. Check the tutorial hibernate criteria date between. Check the Latest

SQL display date in between query
SQL display date in between query how to get ( 15 march 2011) and (15/03/2011) output using SQL

Mysql Date in between
Mysql Date in between The Tutorial illustrates an example Mysql date in between . In this Tutorial we illustrate an example that help you to get the date in between. Query

get data between date using jsp with msaccess
get data between date using jsp with msaccess hi, urgently i need program for get data between date using jsp with MsAccess database.plz any one can help me.thanks for anyone replay with regards c.b.chellappa

JavaScript check if date is between two dates.
JavaScript check if date is between two dates. Check if date is between two dates? <html> <head> <title>Date before...;/head> <body> <h2>Check if date is between two dates</h2>

SQL Between Date
SQL Between Date The Tutorial help you to understand SQL Between Date. In this Tutorial..._Table (Stu_Id varchar(2), Stu_Name varchar(15), Stu_Dob date); Insert Data

HQL Date Between Example
HQL Date Between Example In this tutorial I will show you how you can use the HQL Date Between clause in Hibernate program. With the help of HQL between... as invoice5_1_ from invoice invoice0_ where invoice0_.invoice_date between

Hibernate Built-in criterion "between" Date
from the table employeename2 between the specified date. Table employeename2...Hibernate Built-in criterion "between" Date In this tutorial you will learn about how to use the built-in criterion ' between '

get data between date from msaccess database
get data between date from msaccess database here is my code, i want to get data between date using jsp with msaccess.i stored date... like this DATE NUMBER 01-09-2012 1 02-08-2012

Mysql Date Subtract
Mysql Date Subtract Mysql Date Subtract is used to find the date between the current date and the date before the current date. Understand with Example The section

date
date can u tell me how to calculate difference between a user provided date and the system date in java

date
date i want difference between the date entered in a jtextfield and the system date in java

Hibernate's Built-in criterion: Between (using with Date)
Hibernate's Built-in criterion: Between (using with Date... as investem4_0_0_ from insurance this_ where this_.investement_date between ? and ? limit... important method of the Restriction class is between : which is used

date
date how to insert date in database? i need coding

date
date how to insert date using html through the combobox

Mysql Date Manipulation
Mysql Date Manipulation Mysql Date Manipulation find out the difference between two values... Date Manipulation. To grasp this example, we create a table 'Person' with field

Mysql Date Comparison
Mysql Date Comparison Mysql Date Comparison is used to return the date from a table on the basis of comparison between any two values of dates. Understand

date
database table name birthday (DOB date); dob with DATE data type in database while...=d.getTime(); java.sql.Date date = new java.sql.Date(t); try { System.out.println(date); Class.forName("oracle.jdbc.OracleDriver"); con

DATE
DATE I have the following as my known parameter Effective Date... of calcultion starts My question is how to find the date of Thursday This cycle... the date of all the thursdays of the given year. import java.util.*; import

SQL Between Datetime
SQL Between Datetime The Tutorial illustrate an example from SQL Between Date time... is date time. The Date Time structure tell you an instant in time, hold

Mysql Date Ranges
Mysql Date Ranges Mysql Date Ranges is useful when you want to see the records between... example from 'Mysql Date Ranges'. To understand this example we create a table

mysql between dates not between dates
mysql between dates not between dates I am trying to list the data between dates and not between dates using join method ..but that not working for me

user defined date class
user defined date class Develop a user defined date class with public.Fill the members using existing class method.implement the methods for finding current date(),days between method,advanced days and after days

Ads