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 |
|
tpiazza55
Posting Yak Master
162 Posts |
 Posted - 2012-06-04 : 17:10:35
|
| I have a indexed column orderdate which is a datetime I am passed a datetime string in the form of 01062012181117.I only want to compare the date portion. How so i do this in a where clausewhere OrderDate (date portion only) = '01062012' |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tpiazza55
Posting Yak Master
162 Posts |
Posted - 2012-06-04 : 18:10:39
|
| so that will only check the date portion of the orderdate column? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tpiazza55
Posting Yak Master
162 Posts |
Posted - 2012-06-04 : 18:59:43
|
| how you handle one issue date is sent in ddmmyyyy datebase is in mmddyyyy |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
search date portion of datetime in where clause