Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Problem with epoch time

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Problem with epoch time
# 1  
Old 03-16-2014
Problem with epoch time
Hi All,

I have a weird problem. I have a session log which is in .bin format. I am converting the .bin file to xml format using Informatica(it is an ETL tool) and unix functionality called "convertLogFiles" . All this is working fine. The session log has a date column. After converting the log to xml format, the date value is getting converted to unix time - epoch time. The strange part is, after the conversion the epoch time is 13 digits. Below are some of the date values from the log:

Actual date value:
Code:
2014-03-13 20:30:11



After conversion, Epoch time value:
Code:
1394713811052



Now i need to load this epoch time value to a Oracle table. So i am converting it using the date command in unix. This epoch time value is not proper ! What i mean is, if i convert the epoch value to date format, it is giving some other value!

Code:
date -d @1394713811052
 
Output i am getting 
 
Sun Sep 21 07:04:12 SGT 46166



Please help in resolving this issue. Or is there any way where i can avoid converting the time to epcoh value.
# 2  
Old 03-16-2014
You might be trying something wrong see result here

Code:
[akshay@aix tmp]$ date -d '2014-03-13 20:30:11'
Thu Mar 13 20:30:11 IST 2014

[akshay@aix tmp]$ date -d '2014-03-13 20:30:11' +%s
1394722811

[akshay@aix tmp]$ date -d @$(date -d '2014-03-13 20:30:11' +%s)
Thu Mar 13 20:30:11 IST 2014

[akshay@aix tmp]$ date -d @1394722811
Thu Mar 13 20:30:11 IST 2014

---------- Post updated at 04:09 PM ---------- Previous update was at 04:06 PM ----------

Code:
2014-03-13 20:30:11 != 1394713811052

Code:
$ date --v
date (GNU coreutils) 8.4
Copyright (C) 2010 Free Software Foundation, Inc.

# 3  
Old 03-16-2014
It seems to me there are 3 digits too many, probably it is Epoch in milliseconds:
Code:
$ date -d @1394713811.052
Thu Mar 13 13:30:11 CET 2014

Code:
dd=1394713811052
date -d "@$(echo "$dd/1000"|bc)"

Last edited by Scrutinizer; 03-16-2014 at 08:17 AM..
This User Gave Thanks to Scrutinizer For This Post:
galaxy_rocky
# 4  
Old 03-16-2014
Hi Scrutinizer,

Yes you are correct. The date was in milliseconds. And your solution worked perfectly ! Thank you Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk: time intervals based on epoch time

I have a list of epoch times delimited by "-" as follows: 1335078000 - 1335176700 1335340800 - 1335527400 1335771300 - 1335945600 1336201200 - 1336218000 The corresponding dates are: 20120422 1000 - 20120423 1325 20120425 1100 - 20120427 1450 20120430 1035 - 20120502 1100 ... (3 Replies)
Discussion started by: alex2005
3 Replies

2. Shell Programming and Scripting

Converting real time to epoch time

# date +%s -d "Mon Feb 11 02:26:04" 1360567564 # perl -e 'print scalar localtime(1360567564), "\n";' Mon Feb 11 02:26:04 2013 the epoch conversion is working fine. but one of my application needs 13 digit epoch time as input 1359453135154 rather than 10 digit epoch time 1360567564... (3 Replies)
Discussion started by: vivek d r
3 Replies

3. Shell Programming and Scripting

Shell script to convert epoch time to real time

Dear experts, I have an epoch time input file such as : - 1302451209564 1302483698948 1302485231072 1302490805383 1302519244700 1302492787481 1302505299145 1302506557022 1302532112140 1302501033105 1302511536485 1302512669550 I need the epoch time above to be converted into real... (4 Replies)
Discussion started by: aismann
4 Replies

4. Shell Programming and Scripting

epoch time

Hi all, I got a file with epoch times like this. 1264010700 1264097400 1263529800 1263762900 1263924300 What I want. I want all epoch times which are > current epoch time written to a file. So everything that is < will be ignored and not written to the file. Thanks (3 Replies)
Discussion started by: stinkefisch
3 Replies

5. Shell Programming and Scripting

how to convert date time to epoch time in solaris

Hi, Is there any easy way to convert date time(stored in shell variable ) to epoch time in solaris box? As +%s is working on linux but not on solaris, also -d option is not working. Any suggestion please? (6 Replies)
Discussion started by: anshuman0507
6 Replies

6. Shell Programming and Scripting

Convert Epoch Time to Standard Date and Time & Vice Versa

Hi guys, I know that this topic has been discuss numerous times, and I have search the net and this forum for it. However, non able to address the problem I faced so far. I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies

7. Shell Programming and Scripting

Convert Epoch time format to normal date time format in the same file

I have a file named "suspected" with series of line like these : {'protocol': 17, 'service': 'BitTorrent KRPC', 'server': '219.78.120.166', 'client_port': 52044, 'client': '10.64.68.44', 'server_port': 8291, 'time': 1226506312L, 'serverhostname': ''} {'protocol': 17, 'service': 'BitTorrent... (3 Replies)
Discussion started by: rk4k
3 Replies

8. Shell Programming and Scripting

epoch time

Hi, i need to convert below date/time format into epoch time YYYY-m-d H:M below the example: a=`date +"%F %H:%M"` echo $a Convert $a to epoch time ------------------------------------------------------------------------ lets take an example if $a=1.03 here i want the epoch time... (3 Replies)
Discussion started by: ali560045
3 Replies

9. UNIX for Advanced & Expert Users

Epoch time

Guys, i have a question... I have 2 sets of data say "a" and "a+1" which has values in epoch time.. Question is... if i were to get the time difference where diff = "a+1" - "a" can i convert it back to real time duration after the subtraction... OR i need to convert em first before i do the... (2 Replies)
Discussion started by: 12yearold
2 Replies

10. Shell Programming and Scripting

Epoch time

Guys, i have a question... I have 2 sets of data say "a" and "a+1" which has values in epoch time.. Question is... if i were to get the time difference where diff = "a+1" - "a" can i convert it back to real time duration after the subtraction... OR i need to convert em first before i do the... (1 Reply)
Discussion started by: 12yearold
1 Replies
Login or Register to Ask a Question