| Author: saisrikanthreddy 21 Nov 2008 | Member Level: Gold | Rating:  Points: 3 |
Hey rahul,
You can say month(getdate()) inorder to get the current month of the current date.
All the best.
*************
Regards,
SaiSrikanthReddy
|
| Author: Anil Kumar Pandey 21 Nov 2008 | Member Level: Diamond | Rating: Points: 2 |
hi,
U can use the query like this
Select * from tabname where date=getdate()
Regards
Anil Pandey
Thanks & Regards
Anil Kumar Pandey
|
| Author: Sriman N Vangala 21 Nov 2008 | Member Level: Diamond | Rating: Points: 4 |
you can make use of the getdate() with in the query if you wantot get it directly from backend, but if you want to the system date then it would be better to get it form the .net code by using the function SystemTime which retruns the system's present time.
chk this link this may be helpful to ur requirement:
http://www.geekpedia.com/code117_Get-And-Set-The-System-Date-And-Time.html
|
| Author: Legend 21 Nov 2008 | Member Level: Silver | Rating: Points: 5 |
you can make use of the getdate() with in the query if you wantot get it directly from backend, but if you want to the system date then it would be better to get it form the .net code by using the function SystemTime which retruns the system's present time.
chk this link this may be helpful to ur requirement:
http://www.geekpedia.com/code117_Get-And-Set-The-System-Date-And-Time.html
or
|