Selecting dates in SQL Server

K

Kevinp

I have a table with a date field and one of the
rows has a date value of '2009-03-31
16:39:16.000'.

I'm trying to use a SELECT statement like this:
SELECT * FROM MyTable WHERE fldDate >= '01/01/09'
AND fldDate <= '03/31/09'

The results will not include the above stated
record. Is there some way to change the SQL
statement that will include it?
 
A

Armin Zingler

Kevinp said:
I have a table with a date field and one of the
rows has a date value of '2009-03-31
16:39:16.000'.

I'm trying to use a SELECT statement like this:
SELECT * FROM MyTable WHERE fldDate >= '01/01/09'
AND fldDate <= '03/31/09'

The results will not include the above stated
record. Is there some way to change the SQL
statement that will include it?
Click to expand...

'03/31/09' is equal to '03/31/09 00:00'

'2009-03-31 16:39:16.000' is not before and not equal to 03/31/09 00:00

If you want to include the 31th of March 2009, use

< '04/01/2009'

(which is also true if you use SQLParameters)


Armin
 
A

Armin Zingler

Kevinp said:
I have a table with a date field and one of the
rows has a date value of '2009-03-31
16:39:16.000'.

I'm trying to use a SELECT statement like this:
SELECT * FROM MyTable WHERE fldDate >= '01/01/09'
AND fldDate <= '03/31/09'

The results will not include the above stated
record. Is there some way to change the SQL
statement that will include it?
Click to expand...

'03/31/09' is equal to '03/31/09 00:00'

'2009-03-31 16:39:16.000' is not before and not equal to 03/31/09 00:00

If you want to include the 31th of March 2009, use

< '04/01/2009'

(which is also true if you use SQLParameters)


Armin
 
K

Kevinp

'03/31/09' is equal to '03/31/09 00:00'

'2009-03-31 16:39:16.000' is not before and not equal to 03/31/09 00:00

If you want to include the 31th of March 2009, use

< '04/01/2009'

(which is also true if you use SQLParameters)


Armin
Click to expand...

Yes, I realize that. Entering '04/01/09' is not
acceptable to my users who only want up to
'03/31/09'.
 
K

Kevinp

'03/31/09' is equal to '03/31/09 00:00'

'2009-03-31 16:39:16.000' is not before and not equal to 03/31/09 00:00

If you want to include the 31th of March 2009, use

< '04/01/2009'

(which is also true if you use SQLParameters)


Armin
Click to expand...

Yes, I realize that. Entering '04/01/09' is not
acceptable to my users who only want up to
'03/31/09'.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converted from LINUX time ok, but having issues with the between date. 4
Delete rows with date more than 48 hours with a condition.. 2
Find then highlight in yellow 6
Count between dates 2
Simultaneous calls 4
Count Dates between Dates exclude Text 3
date format in excel imported from an SQL DB. 2
Create List of Dates that fall between 2 Dates 2

Top