Sponsored Content
Operating Systems Solaris how to get the milli seconds from date in sun unix Post 67834 by r2b on Monday 28th of March 2005 03:50:52 PM
Old 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

file creation date including seconds

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

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... (1 Reply)
Discussion started by: r2b
1 Replies

3. HP-UX

a simple way of converting a date in seconds to normal date

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

Converting past date to seconds

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

Current system date in terms of seconds

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

Date format in micro seconds

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

Getting date in seconds with decimals

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

Change the seconds value in date column

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

Regex match date and seconds format

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

Subtract Seconds from Date Command

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
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)
All times are GMT -4. The time now is 04:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy