Mike,
You are the most egregious violator of the UT etiquette. Why do you have to insert your message in this thread? Can’t you just create a message in Chatter, or Sports, or send Kevin a PM?
>Have I mentioned it's great to have you back? I don't have any more idea why Michel let you back than you do but in terms of adding value to members in technical content it was a smart business decision.
>
>Plus I have one more person to discuss sports and music with ;-)
>
>How about those Bengals?! I had season tickets one year when I was working in Cincinnati, up in the nosebleed section. 1986 I think, with Boomer Esiason as QB and Tim McGee as a wideout. The stadium was packed every week. The Bengals have always had great fans even when they weren't good. Good fans, passionate and friendly. Like the city itself, good Germans.
>
>When the Bears, the reigning Super Bowl champions, came to town I passed around songsheets to "Bear Down, Chicago Bears." The reaction was amused, not what you what you would expect in Pittsburgh or New York.
>
>I do not have high expectations of the Bears. My #2 team is the Bengals.
>
>UPDATE: I was in full thrawl at the time with two simultaneous girlfriends . They attended Bengals games about evenly. I believe every man deserves a magic season. At 56 it is nice to remember being competed for. They both had their attributes. Good breasts and a nice butt, respectively. They knew about each other. Leslie commented once that Pam had a good figure walking away. Talk about a backhanded compliment.
>
>
>>I'm assuming you have rows in there "during the day" of Sept 17, maybe with times of 3 pm, ETC.
>>
>>the thing to remember is that when you use '20130917' on a datetime column, there's an implied midnight. So your original query will only capture those rows that occurred on 9/17 at midnight...not ones that happened throughout the day.
>>
>>You can try any of these...
>>
>>
>>
select * from mytable where date_time >= '20130917' and date_time < '20130918'
>>
>>or
>>
>>
select * from mytable where cast(date_time as date) = '20130917'
>>
>>Though the first is likely to perform better than the 2nd....
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham