How to convert date and timestamp?

Login or Register to Ask a Question and Join Our Community

How to convert date and timestamp?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to convert date and timestamp?

08-03-2011

Registered User

41, 0

Join Date: Jan 2011

Last Activity: 19 July 2017, 12:28 PM EDT

Posts: 41

Thanks Given: 10

Thanked 0 Times in 0 Posts

How to convert date and timestamp?

Hi,
I have a file file1 having data as below

Code:

20110501,070742, ,012345678909,09999999999,68.5,
20110501,070236, ,089375855455,09376383333,374.3, 
20110501,070525, ,090345895555,08444233444,206.2,
20110501,230051, ,000934744433,07624262223,480.1,

First field is date(YYYYMMDD) and second field is time stamp(HHMMSS).The timestamp is GMT. Now I have to add 5 hr. and 30 min. to the second field .But now the time will be changed and date also(if time is 23 hrs 00 min and 51 seconds).

the ouput should be:

Code:

20110501,123742, ,012345678909,09999999999,68.5,
20110501,123236, ,089375855455,09376383333,374.3, 
20110501,123525, ,090345895555,08444233444,206.2,
20110502,043051, ,000934744433,07624262223,480.1,

How to do this. Plese help.

Last edited by radoulov; 08-03-2011 at 11:27 AM.. Reason: Code tags.

vsachan

View Public Profile for vsachan

Find all posts by vsachan

08-03-2011

Registered User

1,170, 106

Join Date: Sep 2008

Last Activity: 10 October 2019, 7:06 AM EDT

Posts: 1,170

Thanks Given: 22

Thanked 106 Times in 101 Posts

Asked many times here (similar ones). search "getcalc" in this forum.

If you have DB in your system, then it would be a simple "sql" to do that.

panyam

View Public Profile for panyam

Find all posts by panyam

08-03-2011

Registered User

41, 0

Join Date: Jan 2011

Last Activity: 19 July 2017, 12:28 PM EDT

Posts: 41

Thanks Given: 10

Thanked 0 Times in 0 Posts

There is no function getcalc available. please help if anybody having any idea.

vsachan

View Public Profile for vsachan

Find all posts by vsachan

08-03-2011

Registered User

1,170, 106

Join Date: Sep 2008

Last Activity: 10 October 2019, 7:06 AM EDT

Posts: 1,170

Thanks Given: 22

Thanked 106 Times in 101 Posts

Aplogies for the typo, it is "datecalc".

A link with more details:

https://www.unix.com/answers-frequent...rithmetic.html

panyam

View Public Profile for panyam

Find all posts by panyam

08-03-2011

Registered User

41, 0

Join Date: Jan 2011

Last Activity: 19 July 2017, 12:28 PM EDT

Posts: 41

Thanks Given: 10

Thanked 0 Times in 0 Posts

Thanks panyam. But my question is totally different. I have certain records in a file. First field is YYYYMMDD(Yearmonth and date) and the second field is HHMMSS(Hour,min and sconds).this is 24 Hrs format. Then I have to convert the time in the fields to IST. i.e. I have to add 5 hrs 30 min to the second field. and then obviously i have to check the date.suppose if the time in second field is 233000. then the new time will be 050000. and the date will be incremented by 1. I have to implement this scenario.

sample input file:
----------------

Code:

20110501,070742, ,012345678909,09999999999,68.5,
20110501,070236, ,089375855455,09376383333,374.3, 
20110501,070525, ,090345895555,08444233444,206.2,
20110501,230051, ,000934744433,07624262223,480.1,
.
.
.

Output File:
-----------

Code:

20110501,123742, ,012345678909,09999999999,68.5,
20110501,123236, ,089375855455,09376383333,374.3, 
20110501,123525, ,090345895555,08444233444,206.2,
20110502,043051, ,000934744433,07624262223,480.1,
.
.
.

The date has been changed in the 4th record.

Please help if anybody having any idea.

Last edited by Franklin52; 08-03-2011 at 02:13 PM.. Reason: Please use code tags for data and code samples, thank you

vsachan

View Public Profile for vsachan

Find all posts by vsachan

08-03-2011

Registered User

1,613, 160

Join Date: Oct 2007

Last Activity: 12 February 2019, 12:19 PM EST

Location: USA

Posts: 1,613

Thanks Given: 40

Thanked 160 Times in 150 Posts

Dont know how to do date arithmetic in shell or awk...as it is tedious and cumbersome but here's a perl script you can try. It reads each line from the input file and splits it into fields based on the comma delimiter...then it extracts the year month monthday etc. information from each field and converts it into seconds since the epoch and adds 5.5 hrs (converted into seconds) to it...followed by recalculating the new date and time and putting it into a tm object...

Code:

#!/usr/bin/perl

while (<>) {
    use Time::Local;
    use Time::localtime;

    @f = split /,/, $_;
    $gmt = 5*60*60 + 30*60;

    $yr = substr($f[0], 0, 4) - 1900;
    $mo = substr($f[0], 4, 2) - 1;
    $dy = substr($f[0], 6, 2);
    $hr = substr($f[1], 0, 2);
    $mi = substr($f[1], 2, 2);
    $se = substr($f[1], 4, 2);

    $epoch = timelocal($se,$mi,$hr,$dy,$mo,$yr) + $gmt;
    $tm = localtime($epoch);

    printf("%04d%02d%02d,",$tm->year+1900,$tm->mon+1,$tm->mday);
    printf("%02d%02d%02d,",$tm->hour,$tm->min,$tm->sec);
    printf("%s,%s,%s,%s,\n",$f[2],$f[3],$f[4],$f[5]);
}

Save the above perl script into a file and run it on the command line like...

Code:

your_script_name inputfile

This User Gave Thanks to shamrock For This Post:

shamrock

View Public Profile for shamrock

Find all posts by shamrock

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert Timestamp in text to Serial Date-Time

Hi, I have a data file where the timestamp is in the style of: 2016-10-11 07:01:23.375-500 which is yyyy-mm-dd hh-mm-ss-000 then time conversion from UTC What i need to do is convert these timestamps from the above format to a the Serial Date format (i.e 42,654.2920446 ) now.. if...

2. Shell Programming and Scripting

Convert date in dd mm yyyy format to UNIX timestamp

Hello All, I have a date in DD/MM/YYYY format. I am trying to convert this into unix timestamp. I have tried following: date -d $mydate +%s where mydate = 23/12/2016 00:00:00 I am getting following error: date: extra operand `+%s' Try `date --help' for more information. ...

3. UNIX for Dummies Questions & Answers

Convert Epoch to timestamp in a file

Hi Team, Could you please let me know ,how to convert Epoch column to timestamp in a flat file. "57894"|"1454247163111"|"""HH""" "57897"|"1454247163111"|"""HH""" "7906"|"1454247163111"|"""ss""" I want second field as timestamp. This thread has been moved from a non-technical forum to...

4. 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...

5. Shell Programming and Scripting

Replacing Date in the file with Create date and timestamp

Hello, I have files that with a naming convention as shown below. Some of the files have dates in the file name and some of them don't have dates in the file name. imap-hp-import-20150917.txt imap-dell-gec-import-20150901.txt imap-cvs-import-20150915.txt imap-gec-import.txt...

6. AIX

convert a specific date to a unix timestamp

hello, i have an AIX5.3 machine and i am writing a script to display some processes. inside the script i want to get the time that the process starts and convert it to a unix timestamp. is there a command that i can use to do that? i search the web but all i found is long scripts and it does...

7. Shell Programming and Scripting

Check if a date field has date or timestamp or date&timestamp

Hi, In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date&timestamp. I have to figure out the the data is a date or time stamp or date&timestamp. If it is date then append "<space>00:00:00"...

8. Shell Programming and Scripting

To convert a date(in string format) to unix timestamp

Hi All, I have a string like below. "Mar 31 2009" . I want to convert this to unix time . Also please let me know how to find the unix time for the above string minus one day. For Eg. if i have string "Mar 31 2009" i want to find the unix time stamp of "Mar 30 2009". Thanks in advance,...

9. Shell Programming and Scripting

Convert Unix Timestame to real timestamp

Hello, Did anyone know how to use script (e.g. perl) to conver Unix Timestame to real timestame in GMT+8 ? 1245900787 file:/tmp/a/Test/.txt.swp has created 1245900988 file:/tmp/a/Test/.txt.swp has changed Thu, 25 Jun 2009 11:33:07 GMT+8 file:/tmp/a/Test/.txt.swp has created Thu, 25 Jun...

10. Shell Programming and Scripting

how to convert from timestamp to date format in tcsh

hello all im looking for fast way to convert timestamp format to date format and vaiseversa in tcsh , can it be done? thanks allot

Login or Register to Ask a Question