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 |
|
ljg
Starting Member
4 Posts |
 Posted - 2011-06-10 : 01:05:38
|
| i have 2 date and its format is only month and year.then how to find the difference between these two date.(it not conatin the day part)lj |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-06-10 : 01:49:45
|
The difference in WHAT?in years or in months or in days or in hours or ...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
ljg
Starting Member
4 Posts |
Posted - 2011-06-10 : 02:14:18
|
| hi, thanks for replay. i need difference in month.lj |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-06-10 : 02:21:25
|
quote:
Originally posted by ljg
i have 2 date and its format is only month and year.then how to find the difference between these two date.(it not conatin the day part)lj
what is the data type of the column ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-06-14 : 04:32:41
|
| Post some sample data to know the format of dates you storeMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Find date difference that have no day part