HOW TO TAKE CURRENT DATE AND TIME FROM MYSQL DATABASE
For date
query= "SELECT CURDATE() "
For date and time
query = "SELECT now() "
ForTIME
query = "SELECT Curtime()"
query= "SELECT CURDATE() "
For date and time
query = "SELECT now() "
ForTIME
query = "SELECT Curtime()"
QUERY FOR CURRENT DATE AND TIME INSERT IN MYSQL DATABASE
For date
query_ = "INSERT INTO TABLE(dp_name, dp_date)VALUE ('anuraj)', CURDATE() )"
For date and time
query = "INSERT INTO TABLE (dp_name, dp_date_time)VALUE ('anuraj)', now() )"
ForTIME
query_ = "INSERT INTO TABLE (dp_name, dp_time)VALUE ('anuraj)',curtime() )"
query_ = "INSERT INTO TABLE(dp_name, dp_date)VALUE ('anuraj)', CURDATE() )"
For date and time
query = "INSERT INTO TABLE (dp_name, dp_date_time)VALUE ('anuraj)', now() )"
ForTIME
query_ = "INSERT INTO TABLE (dp_name, dp_time)VALUE ('anuraj)',curtime() )"
How to Type Prefix characters in Microsoft Word?
1. Select the text you want to make a superscript.
2. Press CTRL/SHIFT/=
2. Press CTRL/SHIFT/=
DDDDDDTTT
How to Type Suffix characters in Microsoft Word?
1. Select the text you want to make a superscript.
2. Press CTRL/=
ADDDDDDD
2. Press CTRL/=
ADDDDDDD
Arithmetic Operators in php
Operator | Description | Example | Result |
---|---|---|---|
+ | Addition | x=2 x+2 | 4 |
- | Subtraction | x=2 5-x | 3 |
* | Multiplication | x=4 x*5 | 20 |
/ | Division | 15/5 5/2 | 3 2.5 |
% | Modulus (division remainder) | 5%2 10%8 10%2 | 1 2 0 |
++ | Increment | x=5 x++ | x=6 |
-- | Decrement | x=5 x-- | x=4 |
MESSAGE BOX YES/NO CONDITION IN ASP.NET (VB CODE)
Dim A As MsgBoxResult
A = MsgBox("DO YOU LOVE ME", MsgBoxStyle.YesNo, "143")
If A = MsgBoxResult.Yes Then
MsgBox("I LOVE YOU")
ElseIf A = MsgBoxResult.No Then
MsgBox("I HATE YOU")
End If
A = MsgBox("DO YOU LOVE ME", MsgBoxStyle.YesNo, "143")
If A = MsgBoxResult.Yes Then
MsgBox("I LOVE YOU")
ElseIf A = MsgBoxResult.No Then
MsgBox("I HATE YOU")
End If
Subscribe to:
Posts (Atom)