Search In
If a column is not in date datatype but the inserted values in that columns are as date type.
and you want to update that column in date type but without loosing values in that column.
You can use the following query-
UPDATE `tbl` SET `date1` = ST
DELIMITER $$
DROP PROCEDURE IF EXISTS GetCustomerSearchResult$$
CREATE DEFINER=root@% PROCEDURE GetCustomerSearchResult(
criteria INT
,searchValue VARCHAR(500)
,MinLimit INT
,MaxLimit INT
)
BEGIN
CASE
WHEN criteria=1 /*search b
Checking the date entered by the user correct of not as according to a predefined format or not.
Example 1)
$format = 'd-m-Y';
$input = 'asasasawasa-sldjs';
$date = DateTime::createFromFormat($format, $input);
if($date)
echo 'The Date you
Hello friends,
I am here for share the solution of a MySQL problem.
If you want to change the data type of a column from varchar or any other one to date, you should need to use following query-
UPDATE `tbl` SET `date1` = STR_TO_DATE(`date1`, '%d-%
If you want to extract only the date, we can use the strftime method of Time/Date class, as
2.1.5 :055 > DateTime.now.strftime('%d/%m/%Y')
=> "12/30/2015"
(Here d is used to display date, m displays month and Y display the year in 4-dig
Hello,
I am sharing here how we can take backup of our Project mysql database file and upload it in our Dropbox Account. Advantage using this feature is we can store our database backup in our Dropbox account daily. We can set our script as a cron
Here we can show how you can add the calendar control in your Alloy UI form. The below example explains how you can put your calendar control on textarea in your Alloy UI form.
Example:
<script>
YUI().use(
'aui-datepicke
Hello Reader's! If you have the time stamp in unix time and you need to convert them into Date time format
Then you can use the diffrent ways of doing this in PHP
Let's say the example below:-
$timestamp=1455070324;
echo gmdate("Y-m-d\TH:i:s\Z", $
Date play an important role in any project. We have to change date format according to our need. If we are using PHP 5.2 and lower then for changing date format we have to parse the elements (year, month, day, hour, minute, second) manually using sub
Using Services In Android
Service is an application component which runs in the background and do not have a user interface.Services can be of two forms::
Started
Service can be started from an application component such as Activity
