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 |
|
amodi
Yak Posting Veteran
83 Posts |
 Posted - 2009-09-14 : 09:06:03
|
| Hello Friends,I want to write a simple select statement as follows:select * from tablewhere createdOn = '2009-06-08 11:07:55.987'where condition should be based on "date and time".How can i achieve this?Thansk. |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-09-14 : 09:09:40
|
| u query will gives result based on date and time only.......... |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-09-14 : 09:10:43
|
quote:
where condition should be based on "date and time".
Can you explain more on what do you need here ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-14 : 09:11:59
|
quote:
Originally posted by amodi
Hello Friends,I want to write a simple select statement as follows:select * from tablewhere createdOn = '2009-06-08 11:07:55.987'where condition should be based on "date and time".How can i achieve this?Thansk.
Did it give what you want?MadhivananFailing to plan is Planning to fail |
|
|
|
amodi
Yak Posting Veteran
83 Posts |
Posted - 2009-09-14 : 09:43:05
|
| Sorry for not being clear.Every thing works fine. |
|
|
|
|
|
|
select based on date time