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 - 2006-02-23 : 09:03:24
|
Thomas writes "I have a date field which stored Date and Time.When I query the record with the date format '12-Feb-2006' I did not get any records.Pls send me the answer." |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-23 : 09:06:37
|
Post the query you usedDo you want to find out the rows where Date is '12-Feb-2006'?Select columns from yourTableWhere Datecol>='2006-02-12' and Datecol<'2006-02-13'MadhivananFailing to plan is Planning to fail |
|
|
|
|
|