04-07-2011
i have tried above formula
the output is all like this
00 days 00:0000 days 00:0000 days 00:0000 days 00:0000 days 00:0000 days 00:0000 days 00:0000 days 00:0000 days 00:0000 days 00:0000 days 00:0000 days 00:0000 days 00:00
8 More Discussions You Might Find Interesting
1. Programming
Hi there,
I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks!
YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies
2. Shell Programming and Scripting
I am debugging some code and came across ? in the WHERE cause in a mysql query.
Is this possible and what situations would this be used?
SELECT ip, count
FROM table
WHERE domain=?
thanks & regards (2 Replies)
Discussion started by: hazno
2 Replies
3. Shell Programming and Scripting
Hi there, I have a table that stores multiple records for many different servers, each of which is timestamped ... I wanted to write a query that would enable me to only output the "latest" record (based on timestamp) for each "unique" server. So for example my main table looks like this
... (3 Replies)
Discussion started by: hcclnoodles
3 Replies
4. Shell Programming and Scripting
Hi,
I want to access mysql query from database , for that i have tried the below code
#! /bin/bash
TABLE_NAME=database1
USER_NAME=root
IP_ADDR=111.20.9.256
somevar=`echo "select altid from alert where altid='2724'"| mysql -h $IP_ADDR -u $USER_NAME $TABLE_NAME `
echo $somevar
... (1 Reply)
Discussion started by: aish11
1 Replies
5. Shell Programming and Scripting
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (11 Replies)
Discussion started by: aish11
11 Replies
6. Programming
Hello
i have created mysql query to compare to values and get difference in percentage
as following:
SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies
7. Programming
Hi All,
i have a table in mysql with the following data
Table name Test
Assettype Serial_No Status location
Mouse 123456 In Stock chennai
Mouse 98765 Allocated chennai
Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies
8. Shell Programming and Scripting
Hello Friends,
I am using check_mysql_query plugin in nagios to query database and get output. query is working fine but output which i am getting contain query. I want to remove query from output and give custom message which will be simple and understandable.
Can you help me here with any... (5 Replies)
Discussion started by: ghpradeep
5 Replies
LEARN ABOUT SUNOS
mlib_videocoloryuv444seq_to_abgrint
mlib_VideoColorYUV444seq_to_ABGRint(3MLIB) mediaLib Library Functions mlib_VideoColorYUV444seq_to_ABGRint(3MLIB)
NAME
mlib_VideoColorYUV444seq_to_ABGRint - color convert YUV sequential to ABGR interleaved
SYNOPSIS
cc [ flag... ] file... -lmlib [ library... ]
#include <mlib.h>
void mlib_VideoColorYUV444seq_to_ABGRint(mlib_u32 *ABGR, const mlib_u8 *Y, const mlib_u8 *U, const mlib_u8 *V, const mlib_u8 *A_array,
mlib_u8 A_const, mlib_s32 w, mlib_s32 h, mlib_s32 dlb, mlib_s32 slb);
DESCRIPTION
The Y, U, V pixel streams are converted into an ABGR pixel stream. All pixel components are 8-bit unsigned integers. All buffers have
dimensions w and h.
The alpha values for this function work in the following fashion:
o If A_array pointer is not NULL, the values are taken from there. It has to have the same dimensions as the Y buffer.
o If A_array pointer is NULL, the alpha values for every pixel are set to A_const.
The following equation is used:
|R| |1.1644 0.0000 1.5966| [|Y| | 16.0000|]
|G| = |1.1644 -0.3920 -0.8132| * [|U| - |128.0000|]
|B| |1.1644 2.0184 0.0000| [|V| |128.0000|]
PARAMETERS
The function takes the following arguments:
ABGR Pointer to output buffer.
Y Pointer to Y input buffer.
U Pointer to U input buffer.
V Pointer to V input buffer.
A_array Array of alpha values.
A_const Constant alpha value.
w Image width in pixels.
h Image height in lines.
dlb Linebytes for output buffer.
slb Linebytes for input buffers.
RETURN VALUES
None.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Evolving |
+-----------------------------+-----------------------------+
|MT-Level |MT-Safe |
+-----------------------------+-----------------------------+
SEE ALSO
mlib_VideoColorYUV420seq_to_ARGBint(3MLIB), mlib_VideoColorYUV411seq_to_ARGBint(3MLIB), mlib_VideoColorYUV422seq_to_ARGBint(3MLIB),
mlib_VideoColorYUV444seq_to_ARGBint(3MLIB), mlib_VideoColorYUV420seq_to_ABGRint(3MLIB), mlib_VideoColorYUV411seq_to_ABGRint(3MLIB),
mlib_VideoColorYUV422seq_to_ABGRint(3MLIB), mlib_VideoColorYUYV422int_to_ARGBint(3MLIB), mlib_VideoColorYUV444int_to_ARGBint(3MLIB),
mlib_VideoColorYUYV422int_to_ABGRint(3MLIB), mlib_VideoColorYUV444int_to_ABGRint(3MLIB), mlib_VideoColorUYVY422int_to_ARGBint(3MLIB),
mlib_VideoColorUYVY422int_to_ABGRint(3MLIB), mlib_VideoColorUYV444int_to_ARGBint(3MLIB), mlib_VideoColorUYV444int_to_ABGRint(3MLIB),
attributes(5)
SunOS 5.10 10 Nov 2004 mlib_VideoColorYUV444seq_to_ABGRint(3MLIB)