Computing.Net > Forums > Database > Sql query

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Sql query

Reply to Message Icon

Name: MindHunter
Date: February 28, 2009 at 22:49:15 Pacific
OS: Windows XP
Subcategory: MS SQL Server
Comment:

I have a 2 datetime field fromdate & todate in table which has both date and time value.
fromdate store only start date like 01-01-2009 & todate store todate 01-04-2009
Now i want to get the records like from date =01-02-2009 and todate=01-04-2009



Sponsored Link
Ads by Google

Response Number 1
Name: wizard-fred
Date: March 3, 2009 at 15:41:49 Pacific
Reply:

Either write the query to include the time
or remove the time from the fields.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Sql query

Need help with SQL-query (access) www.computing.net/answers/dbase/need-help-with-sqlquery-access/209.html

MS Access SQL query www.computing.net/answers/dbase/ms-access-sql-query/286.html

Need SQL Query www.computing.net/answers/dbase/need-sql-query/366.html