Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-28 : 09:07:39
|
| falcon_ette writes "hi thereI have created a database to store the dates the venues will be available. I.e an entry date and exit date for a particular venue.EG. Entry date(01/03/2001) and Exit date (06/03/2001)However when I'm searching between those dates it won't read the available dates. EG. when searching for a venue between entry date (02/03/2001)and exit date(05/03/2001) it won't work.When searching outside those dates it will bring up the information, like entry date(28/02/2001) and exit date (07/30/2001).How can I store this data better in my sql server database?Its like the database can't see that the venue is avilable for the 01,02,03,04,05 and 06 of March. How can I make it see this?Pleez help...falcon_ette" |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2001-11-28 : 09:25:14
|
| Given your other question, this must be a date format problem. Parts of your programming environment disagree on whether to interpret 'aa/bb/cccc' as dd/mm/yyyy or mm/dd/yyyy.Send literal date strings in an unambiguous format like 'yyyymmdd'(See BOL "Writing International Transact-SQL Statements") |
 |
|
|
|
|
|
search between dates