|
...for the moment.... thank you for your kind replies
|
|
|
|
|
how to convert an integer to days months years
i have a number of days resulted from sum of datediff to many rows as integer
i want to convert this days into days months years
like this
pr start end days_diff
-------------------------------------------------------
237 2010-06-01 2010-11-30 182
237 2010-12-01 2011-05-31 181
237 2011-06-01 2012-05-31 365
237 2012-06-01 2013-05-31 364
237 2013-06-01 2014-05-31 364
this total a 1456 days
i want to convert this days into
4 years 0 months 1 days
when i use the regular sum for each record into days months years it creates
3 years 12 months 1 days
or any way that produce the same result even not by calculate the sum of the days difference
but produce the same result
4 years 0 months 1 days
not
3 years 12 months 1 days
thanks for help
Lost & Forgotten
|
|
|
|
|
I didn't got, how you compute the years, months and days?
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
start end
-------------------------------------------------------
2010-06-01 2010-11-30
2010-12-01 2011-05-31
2011-06-01 2012-05-31
2012-06-01 2013-05-31
2013-06-01 2014-05-31
suppose this an experience periods
i want to get total of this experience
thanks for help
Lost & Forgotten
|
|
|
|
|
OK...
Get minimum of start (select min(start) from ... where ...)
Get maximum of end (select max(end) from ... where ...)
Do datediff between the two...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
thats right in case the periods are connected some cases the periods not connected like
start end
-----------------------------
2010-06-01 2010-11-30
2011-06-01 2012-05-31
2013-06-01 2014-05-31
Lost & Forgotten
|
|
|
|
|
I see...
In that case you can do something like this
select sum(datediff(d, start,end)) from ... where ...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
How do you do the calculation? If the number of months comes out at 12 then that is 1 year.
|
|
|
|
|
start end
-------------------------------------------------------
2010-06-01 2010-11-30
2010-12-01 2011-05-31
2011-06-01 2012-05-31
2012-06-01 2013-05-31
2013-06-01 2014-05-31
suppose this an experience periods
i want to get total of this experience
thanks for help
Lost & Forgotten
|
|
|
|
|
Assuming you are storing the values as DateTime types, then you can just use a simple subtraction to get a difference value, which can be converted to years, months and days.
|
|
|
|
|
You'll need to pick a starting date, since different months have a different number of days.
For example, 30 days from 1st March would be 30 days; from 1st April, it would be one month; from 1st February 2014, it would be one month and two days; from 1st February 2012, it would be one month and one day.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi,
I would like to ask how can I make a complete silent installation and configuration for the MySQL server.
i have downloaded the Windows (x86, 32-bit), MSI Installer and I want to make a silent installation for my setup package.
Technology News @ www.JassimRahma.com
|
|
|
|
|
First result on Google for "MySql Windows Silent Install":
For example, to perform a quiet installation (which shows no dialog boxes or progress):
msiexec /i mysql-5.1.73.msi /quiet
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
what about the configuration setting such as windows service name, port, password, etc. I mean the screen which pops up after the installation. how can I run it in a Quiet! mode?
Technology News @ www.JassimRahma.com
|
|
|
|
|
|
Thanks
Technology News @ www.JassimRahma.com
|
|
|
|
|
Just noting that if your intent is that your application will be doing all of the database administration then choosing a database that is less full featured might be a better option. And choosing an embedded database might be a better option as well.
|
|
|
|
|
I am currently running mssql 2008 SSRS on hosting server and whenever I view my report on chrome browser my report shrinks to 25% of the total page width. Please what do I need to do?
Kenny
|
|
|
|
|
|
Hi,
I am having a problem saving from my php for to MySQL database. I am not sure if the problem is at the PHP level or database level.
here is the form:
http://www.jassimrahma.com/contactme[^]
and when submiting arabic characters... it will be saved as unreadable characters like this:
http://www.jassimrahma.com/arabic.png[^]
My database character set is UTF-8 Unicode and Collation is utf8_general_ci
here is my table DDL:
CREATE TABLE `mubadara_messages` (
`message_id` int(11) NOT NULL AUTO_INCREMENT,
`message_from_name` varchar(255) DEFAULT NULL,
`message_from_email` varchar(255) DEFAULT NULL,
`message_subject` varchar(255) DEFAULT NULL,
`message_body` text,
`message_ip_address` varchar(255) DEFAULT NULL,
`created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`message_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
and this is my PHP:
require 'PHPMailer/class.phpmailer.php';
$message_visitor_name = $_POST['txtName'];
$message_visitor_email = $_POST['txtEmail'];
$message_subject = $_POST['txtSubject'];
$message_body = $_POST['txtMessage'];
$message_ip_address = $_SERVER['REMOTE_ADDR'];
$mysql_connection = mysql_connect('mysql.jassimrahma.com', 'jassimdb', 'Mujtaba2013');
mysql_select_db('jassimrahma_com', $mysql_connection);
$mysql_command = "INSERT INTO mubadara_messages (message_from_name, message_from_email, message_subject, message_body, message_ip_address) VALUES ('$message_visitor_name', '$message_visitor_email', '$message_subject', '$message_body', '$message_ip_address')";
$mysql_result = mysql_query($mysql_command, $mysql_connection) or die(mysql_error());
mysql_close($mysql_connection);
exit(header("Location: thankyou"));
can anyone help please
Thanks,
Jassim
Technology News @ www.JassimRahma.com
modified 6-Mar-14 5:57am.
|
|
|
|
|
Not sure. You might need to add a
mysql_set_charset('utf8');
between the connection and the selection of the db.
|
|
|
|
|
Hi,
I want to know if there is any way to retrieve an entire row that has a column with least creation time without using top.
Let us take a sample table named Patient
-----------------------------------------------------------
PatientId Observation Time Value
-----------------------------------------------------------
1 Temp 2014-02-19 03:55:00 35
1 Temp 2014-02-19 03:45:00 37
1 Weight 2014-02-19 03:40:00 60
If i am given the PatientId and Observation, I need to retrieve the the row with minimum creation time
For patient id 1 and observation Temp this would be the row
1 Temp 2014-02-19 03:45:00 37
since it has 2014-02-19 03:45:00 as minimum creation time
|
|
|
|
|
WITH FirstObservation AS (
SELECT PatientID,Observation,Min(Time) Time
FROM MyTable
WHERE PatientID = @PatientID
AND Observation = @Observation
GROUP BY PatientID,Observation
)
SELECT PatientId,Observation,TIME,Value
FROM MyTable m
JOIN FirstObservation f
ON m.PatientID = f.PatientID
AND m.Observation = f.Observation
AND m.Time = f.Time
|
|
|
|
|
Why not using order by and top? Because that is can be fast and effective, specially when you have an index on time column?
Or just because it's an exercise you got at school?
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
Kornfeld Eliyahu Peter wrote: Why not using order by and top? Just a guess; "it's too slow"
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|