| Author: Neelesh Parkhi 02 Jun 2008 | Member Level: Silver Points : 2 |
for using datediff
through this function you can fine all three day,month,year for that yo have to write this sentance
select datediff(days,[column_name1],[column_name2])
for month datediff(monts,[column_name1],[column_name2])
for year datediff(year,[column_name1],[column_name2])
|
| Author: Kamal 02 Jun 2008 | Member Level: Gold Points : 2 |
good info.
For Get First and Last day of Week from Date
|
| Author: Kapil Dhawan 17 Jun 2008 | Member Level: Gold Points : 2 |
Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code is going to help lots of guys.
Ton Thanks to you
Regards,
Kapil
|