Timestamp problem


 
Thread Tools Search this Thread
# 1  
Timestamp problem

I have a date/timestamp problem I can't figure out. I have an Oracle table with a column DEL_TIMESTAMP defined as a NUMBER. The min and max values in the column are:

6.3417E+17
6.3470E+17

the bottom value is: 634700000000000000

Is this the time since the epoch? How does this represent date/time?

any helped is appreicated.

thanks.
# 2  
Hammer & Screwdriver Current epoxh time

As I type this, the current epoch time in seconds is:
1334761483

or formatted to see how many digits:
1,334,761,483
so only ten digits.

Thus, no idea what a 17 digits number would represent. Maybe seconds since the dinosaurs ruled the planet?
# 3  
Quote:
6.3417E+17
6.3470E+17
This is a field display overflow. The number is being displayed as an exponential because the display field is not wide enough. It has probably come from a program error. Time to look at the code.
 

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep lines between last hour timestamp and current timestamp

So basically I have a log file and each line in this log file starts with a timestamp: MON DD HH:MM:SS SEP 15 07:30:01 I need to grep all the lines between last hour timestamp and current timestamp. Then these lines will be moved to a tmp file from which I will grep for particular strings. ... (1 Reply)
Discussion started by: nms
1 Replies

2. Shell Programming and Scripting

AIX : Need to convert UNIX Timestamp to normal timestamp

Hello , I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt Contents of... (6 Replies)
Discussion started by: rahul2662
6 Replies

3. Shell Programming and Scripting

Problem with Timestamp

Hi Team, i need some help on finding one hour back time. if current time is 5:18:22 means i have to find 4:18:22 i am having scenario to pull record which as got inserted morethan one hour back in table time stamp is 2014-12-22 05:15:13.788875 can any one help me on this Thanks Vij (5 Replies)
Discussion started by: bhaskar v
5 Replies

4. Shell Programming and Scripting

To check timestamp in logfile and display lines upto 3 hours before current timestamp

Hi Friends, I have the following logfile. Currently time in india is 07/31/2014 12:33:34 and i have the following content in logfile. I want to display only those entries which contain string 'Exception' within last 3 hours. In this case, it would be the last line only I can get the... (12 Replies)
Discussion started by: srkmish
12 Replies

5. Shell Programming and Scripting

Identifying files with a timestamp greater than a given timestamp

I need to be able to identify files with file timestamps greater than a given timestamp. I am using the following solution, although it appears to compare files at the "seconds" granularity and I need it at the milliseconds. When I tested my solution, it missed files that had timestamps... (3 Replies)
Discussion started by: nkm0brm
3 Replies

6. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Hi All, I am new to unix programming. I am trying for a requirement and the requirement goes like this..... I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies

7. UNIX for Dummies Questions & Answers

Appending timestamp problem

Hi, I am trying to insert a timestamp after all the file names in a folder,after the timestamp is created in the filename the file size is becoming zero bytes. please tell me where I am doing it wrong. I have declared the variable in starting of my script. timestamp=`date... (1 Reply)
Discussion started by: shruthidwh
1 Replies

8. Shell Programming and Scripting

Getting a relative timestamp from timestamp stored in a file

Hi, I've a file in the following format 1999-APR-8 17:31:06 1500 3 45 1999-APR-8 17:31:15 1500 3 45 1999-APR-8 17:31:25 1500 3 45 1999-APR-8 17:31:30 1500 3 45 1999-APR-8 17:31:55 1500 3 45 1999-APR-8 17:32:06 1500 3 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies

9. Programming

timestamp conversion problem.

Hi all. I have the following code: #include<stdio.h> #include<time.h> int main() { struct tm tm; time_t time = 1262322000; /*Jan, 01, 2010*/ char temp; int i = 0; while(i < 4) { memset(temp, 0, 128); localtime_r(&time,... (2 Replies)
Discussion started by: adm1n
2 Replies

10. Shell Programming and Scripting

timestamp problem

hi, from a shell script I am copying 2 different set of files in 2 different directories and then it ftp the same set files to another server 2 different directories. the dest directories where it is copying the files own by a different user and required permission is there... (0 Replies)
Discussion started by: sankar
0 Replies

Featured Tech Videos