Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Re: optimal sel...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 3 Topic 11027 of 11517
Post > Topic >>

Re: optimal selection of all records for a certain month (illegal

by metaperl <metaperl@[EMAIL PROTECTED] > May 8, 2008 at 11:50 AM

On May 8, 2:09 pm, metaperl <metap...@[EMAIL PROTECTED]
> wrote:
> First a simple question: Is it allowed to provide a date range that
> has an illegal date.

No it isn't:

SELECT * FROM fut WHERE last_update_date BETWEEN '2007-09-01' AND
'2007-09-31';  -- ERROR
 




 3 Posts in Topic:
optimal selection of all records for a certain month (illegal da
metaperl <metaperl@[EM  2008-05-08 11:09:26 
Re: optimal selection of all records for a certain month (illega
metaperl <metaperl@[EM  2008-05-08 11:50:19 
Re: optimal selection of all records for a certain month (illega
"Plamen Ratchev"  2008-05-08 17:17:08 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 1:09:17 CST 2008.