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 |
|
spacemonkey
Starting Member
8 Posts |
 Posted - 2010-04-14 : 08:15:59
|
| Hi guys,I wanted to calculate difference between two different days. The problem is that I don’t have these fields stored as date. If they were stored as dates then I could do a Datediff and get my results. Is there another ways to do this. I was thinking of using substring to find the day and then do a subtract but that probably is not going to work either. Any advice? |
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-04-14 : 08:28:37
|
| Can you post Which format you are using for those fields some sample dataAs if you can convert it into date time field.Vaibhav TTo walk FAST walk ALONE To walk FAR walk TOGETHER |
 |
|
|
|
|
|
Day Difference(Date not stored as datatype)