Sql Selecting Records

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

usharani.t (6/28/2011)
How to select Records between two dates '06-06-2010' and '06-06-2011' in sql

Here is how you would select rows from a table where a column named date_column had a value between two date specific values:

SELECT *

FROM my_schema_name.my_table_name

WHERE my_date_column BETWEEN '06-06-2010' AND '06-06-2011' ;

Is that what you were looking for?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

usharani.t Ten Centuries Points: 1033 More actions · Answer 2

Ten Centuries

Points: 1033

June 29, 2011 at 12:12 am

Ya thanks i got the answer...........