July 10, 2013

to search whether a date is in between two date fields through my sql query

How to search whether a date is in between two date fields through my sql query




see the below table

----------------------------------------------------------
id | start_date    | end_date     | amount | status  | particular
-----------------------------------------------------------
1  | 12-02-2012 |13-07-2013  | 1729    | active  | Zulily
-----------------------------------------------------------
2  | 07-02-2014 |23-02-2014  | 1989   | active  | IOS 7
-----------------------------------------------------------
3  | 07-03-2014 |16-03-2014  | 1987    | active  | Windows 8.1
-----------------------------------------------------------
4  | 12-06-2014 |13-07-2014  | 1987    | active  | Ouya
-----------------------------------------------------------
5  | 12-10-2014 |28-11-2014  |2013    | active  | Comet C/2012
 -----------------------------------------------------------




 SQL query : select * from tbl_interest_rates where now() between start_date and  end_date;
Dated : 10 jully 2013

result  : 1  | 12-02-2012 |13-07-2013  | 1729    | active  | Zulily



This example will find whether the given date is inbetween dates in the given table.

+Shimjith Kumar
+Vipin Cp


http://belazy.blog.com/

July 03, 2013

How to change password of adminstrator from user account in window xp

To change password of administrator from user account in window x p

1) Go to C:/windows/system32.
2) Copy cmd.exe and paste it on
desktop.
3) Rename cmd.exe to sethc.exe.
4) Copy the new sethc.exe to system
32,when windows asks for overwriting
the file,then click yes.
5) Now Log out from your

guest account

and at the user select window,press shift key 5 times.
6) Instead of Sticky Key confirmation dialog,command prompt with

full administrator privileges

will open.
7) Now type “ NET USER ADMINISTRATOR “yournewpassword” and press enter.
You will see “ The Command completed successfully” and then exit the command prompt and login into administrator with your new password.

How to reset administrator password

There is a chance you might have forgot administrator password if you havent touched with your system for a long time, if you are using windows xp try this

open the system in safe mode ( you can do this by press f8 after your restart

go to run (windows + r) then type " control userpasswords2 " , a popup window will open listing all users in your system, select your user and reset password

Thanks for reading ... your name will be saved for our future reference....

Read more: http://javabelazy.blogspot.com/p/tech.html#ixzz2nvgQ0I9a



http://belazy.blog.com/

Facebook comments