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 |
|
kJeyakar
Starting Member
1 Post |
 Posted - 2005-05-06 : 03:01:22
|
| OrderDT Between {ts '2004-09-13 00:00:00'} AND {ts '2004-09-15 00:00:00'}is not fetching data bwtenn 13 and 15 dates. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-05-06 : 15:58:13
|
What is {ts '2004-09-13 00:00:00'} Is that some non-SQL Server syntax?quote:
Originally posted by kJeyakar
OrderDT Between {ts '2004-09-13 00:00:00'} AND {ts '2004-09-15 00:00:00'}is not fetching data bwtenn 13 and 15 dates.
CODO ERGO SUM |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-07 : 00:34:44
|
Well, if you search for {ts on Google, here is the first thing that comes up:http://ai.eecs.umich.edu/people/conway/TSsuccesses/TSsuccesses.htmlIt's actually an ODBC format I believe though that will work in any database (SQL Server, Oracle, mySQL, etc).Run this in the master database:SELECT * FROM sysobjects WHERE crdate BETWEEN {ts '2004-09-13 00:00:00'} AND {ts '2005-09-15 00:00:00'}MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-05-09 : 13:32:20
|
| And moved to the developer forum.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
|
|
Date format error