Help converting date-time value to decimal [solved]
Hi
I need help to do some calculation in script.
I have a monitor program (munin) that I would like to log uptime information from a server.
The script looks like this (not complete):
Output from this is a long line. Start of it is omitted. End looks always the same.
I can get 22 (days) and 18(hours) out from this but I like to see the output like this uptime.value 22.75
So I need to calculate 22+18/24 Days+Hour/24
I have tried different solution with printf, but can not get it to calculate.
Last edited by Jotne; 01-01-2011 at 12:16 PM..
Reason: Solved
Hi all,
I'm trying to convert a decimal number into an integer number; I'm doing this:
n=`echo |awk '{ print "'"$mem"'"*10}'`
where the variable mem is equal to 3.7
I'd like to obtain 37, but the expression above gives me 30.
Help please!!!!
thx a lot (4 Replies)
The shell mentioned below will show a warning if the page takes more than 6 seconds to load.
The problem is that myduration variable is not an integer. How do I convert it to integer?
myduration=$(curl http://192.168.50.1/mantisbt/view.php?id=1 -w %{time_total}) > /dev/null ; ] && echo... (3 Replies)
I am writing a bash script to do some parsing on a log and I am running into a problem when it comes to converting only certain sections of the file from hex to ascii or hex to decimal.
Data Example:
The hex values after Hardware and SW Version I need to convert from Hex to ASCII and the... (16 Replies)
Hi all ,
I need to know how to convert a time stamp entered by the user to be converted to GMT/UTC(epoch time) using mktime() and gmtime()
for exapample the input will be put in the form
ptm.tm_sec = 0;
ptm.tm_min = 59;
ptm.tm_hour = 11;
ptm.tm_mday = 20;... (2 Replies)
I need code for converting a string to a negative decimal value.
For ex, i have the value in the form of a string (5489.95-) i need to convert it into decimal value (-5489.95) while getting output using printf command.
i know how to get as a string
a="5489.95-"
printf "%10s"$a >>xyz.dat
... (5 Replies)
Hi all,
I need a script to do some date/time conversion. It should take as an input a particular time. It should then generates a series of offsets, in both hour:minute form and number of milliseconds elapsed.
For 03:00, for example, it should give back 04:02:07 (3727000ms*) 05:04:14... (2 Replies)
I'd like to convert a date string in the form of sun aug 19 09:03:10 EDT 2012, to unixtime timestamp using awk.
I tried
This is how each line of the file looks like, different date and time in this format
Sun Aug 19 08:33:45 EDT 2012, user1(108.6.217.236) all: test on the 17th
... (2 Replies)
How to convert decimal value to hex and than take 1st digits as variable
sample data
84844294,5,6
51291736,2,3
84844294,5,6
51291736,2,3
i can use {printf "%x,%d\n",$1,$2} but than i want to filter base on 1st hex digit 1st recrd (1 Reply)
Discussion started by: before4
1 Replies
LEARN ABOUT PHP
mssql_connect
MSSQL_CONNECT(3)MSSQL_CONNECT(3)mssql_connect - Open MS SQL server connectionSYNOPSIS
resource mssql_connect ([string $servername], [string $username], [string $password], [bool $new_link = false])
DESCRIPTION mssql_connect(3) establishes a connection to a MS SQL server.
The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling
mssql_close(3).
PARAMETERS
o $servername
- The MS SQL server. It can also include a port number, e.g. hostname:port (Linux), or hostname,port (Windows).
o $username
- The username.
o $password
- The password.
o $new_link
- If a second call is made to mssql_connect(3) with the same arguments, no new link will be established, but instead, the link
identifier of the already opened link will be returned. This parameter modifies this behavior and makes mssql_connect(3) always
open a new link, even if mssql_connect(3) was called before with the same parameters.
RETURN VALUES
Returns a MS SQL link identifier on success, or FALSE on error.
CHANGELOG
+--------+------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+------------------------------------+
| 5.1.0 | |
| | |
| | The $new_link parameter was added |
| | |
+--------+------------------------------------+
EXAMPLES
Example #1
mssql_connect(3) example
<?php
// Server in the this format: <computer><instance name> or
// <server>,<port> when using a non default port number
$server = 'KALLESPCSQLEXPRESS';
// Connect to MSSQL
$link = mssql_connect($server, 'sa', 'phpfi');
if (!$link) {
die('Something went wrong while connecting to MSSQL');
}
?>
SEE ALSO mssql_close(3), mssql_pconnect(3).
PHP Documentation Group MSSQL_CONNECT(3)