03-28-2005
how to get the milli seconds from date in sun unix
hi all
how do we get the milli seconds in sun unix?
i am using
date +%Y%m%d%H%M%S
to get the unique id and create the file based on this.
but the problem is that if process to load the table takes only less than 1 sec i am getting errror on my table which have the primary key.
how do i get the milli seconds portion of the date in sun unix. i need to use this shell program.
any help is greatly appreciated.
thanks
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
Is anybody can help me to get the file creation date with seconds?
-rw-r--r-- 1 opsc system 422550845 Aug 22 15:41 StatData.20020821
Thanks in advance
Krishna (7 Replies)
Discussion started by: krishna
7 Replies
2. Shell Programming and Scripting
hi all
how do we get the milli seconds in sun unix?
i am using
date +%Y%m%d%H%M%S
to get the unique id and create the file based on this.
but the problem is that if process to load the table takes only less than 1 sec i am getting errror on my table which have the primary key.
how... (1 Reply)
Discussion started by: r2b
1 Replies
3. HP-UX
Hi all!
I'm working on a HPUX system, and I was wondering if there is a simple way to convert a date from seconds (since 1970) to a normal date.
Thanks (2 Replies)
Discussion started by: travian
2 Replies
4. Shell Programming and Scripting
Need a little help developing a ksh script. Have read through Perderabo's datecalc routine and it does not seem to fit the function I am looking for. Basically what I am trying to do is find any file (in a specific directory) that was created within the last five minutes. I am not a programming... (3 Replies)
Discussion started by: synergy_texas
3 Replies
5. UNIX for Dummies Questions & Answers
Hello Friends,
I've been struggling with extreme nagios passive service checks. In order to trigger a nagios passive service im going to write an easy shell script like below and will run it in crontab.
As im working on Solaris 10 servers i used "S" instead of lowercase "s" below
#!/bin/sh... (2 Replies)
Discussion started by: EAGL€
2 Replies
6. Shell Programming and Scripting
Can i get date format in micro seconds in unix
example
2012-01-27- 12.22.04.568722
Any help is appreciable (2 Replies)
Discussion started by: srichunduru
2 Replies
7. Shell Programming and Scripting
I am trying to get date to display decimal
Desired output 1350386096256.12
I know this can be done with printf, but are not able to make it work.
I have tested this and many otherprintf "%.2f" $(($(date +%s%N)/1000000)) (8 Replies)
Discussion started by: Jotne
8 Replies
8. Shell Programming and Scripting
Hello,
I have a file with below contents and need to set seconds value to 00 (as you can see few time stamps are with 01 seconds)
18:16:00 8192 7301 89 11
18:21:00 8192 7305 89 11
18:26:00 8192 7306 89 11
18:31:00 8192 7306 ... (6 Replies)
Discussion started by: reddyr
6 Replies
9. Shell Programming and Scripting
Hi
$ awk '{print $1," ",$4}' access.log | sort | uniq -c| sort -nr | head -n20
62 192.168.10.6
How can get the result like
62, 192.168.10.6, 14:40
62, 192.168.10.32, 47:57
I tried modifying -
$ awk '{print $1," ",$4}' access.log | sort | uniq -c| sort -nr | head -n20 | awk... (3 Replies)
Discussion started by: ashokvpp
3 Replies
10. Shell Programming and Scripting
Hi,
Need to subtract 5 seconds after syncing my Linux server from NTP like;
#ntpdate time.myorg.int.
This script will only run once in each morning at 9 AM.
Please help me. (4 Replies)
Discussion started by: refra
4 Replies
LEARN ABOUT PHP
odbc_foreignkeys
ODBC_FOREIGNKEYS(3) 1 ODBC_FOREIGNKEYS(3)
odbc_foreignkeys - Retrieves a list of foreign keys
SYNOPSIS
resource odbc_foreignkeys (resource $connection_id, string $pk_qualifier, string $pk_owner, string $pk_table, string $fk_qualifier,
string $fk_owner, string $fk_table)
DESCRIPTION
Retrieves a list of foreign keys in the specified table or a list of foreign keys in other tables that refer to the primary key in the
specified table
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $pk_qualifier
- The primary key qualifier.
o $pk_owner
- The primary key owner.
o $pk_table
- The primary key table.
o $fk_qualifier
- The foreign key qualifier.
o $fk_owner
- The foreign key owner.
o $fk_table
- The foreign key table.
RETURN VALUES
Returns an ODBC result identifier or FALSE on failure.
The result set has the following columns:
oPKTABLE_QUALIFIER
oPKTABLE_OWNER
oPKTABLE_NAME
oPKCOLUMN_NAME
oFKTABLE_QUALIFIER
oFKTABLE_OWNER
oFKTABLE_NAME
oFKCOLUMN_NAME
oKEY_SEQ
oUPDATE_RULE
oDELETE_RULE
oFK_NAME
oPK_NAME
If $pk_table contains a table name, odbc_foreignkeys(3) returns a result set containing the primary key of the specified table and all of
the foreign keys that refer to it.
If $fk_table contains a table name, odbc_foreignkeys(3) returns a result set containing all of the foreign keys in the specified table and
the primary keys (in other tables) to which they refer.
If both $pk_table and $fk_table contain table names, odbc_foreignkeys(3) returns the foreign keys in the table specified in $fk_table that
refer to the primary key of the table specified in $pk_table. This should be one key at most.
PHP Documentation Group ODBC_FOREIGNKEYS(3)