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 |
|
BuddyRam
Starting Member
17 Posts |
 Posted - 2007-07-16 : 06:21:48
|
| Hello,I have to compare the two time fields but I have to check the date part only.I am using folloowing query:Select convert(varchar(10),[date],103) from tbl_event where convert(varchar(10),[date],103)>= Convert(varchar(10),getdate(), 103);but its not comaring correctly whem I am saying >= then it is giving all values from that table except matching date record.some one can help in this reardsCheersRam |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Date Comarision problem please help