04-14-2009
conversion of different timestamp to standard timestamp
hi
i need a scrit to convert one date format to another. for example
i have three columns in a file which gets a different format, but lastly i want output
with stadard timestamp as "yyyy-mm-dd hh:mm:ss"
column1 column2 column3
2/28/2009 8:03 PM Mchenry: Shawna 2/28/2009 8:03 2/28/2009
3/28/2009 6:03 PM phanj: ray 3/28/2009 8:03 3/28/2009
4/8/2009 4:03 PM hcary: jun 4/8/2009 8:03 4/8/2009
2/9/2009 08:03 PM ghtar: jan 2/09/2009 8:03 2/09/2009
coloumn 1 contains a PM and name ...output should be as standard timestamp .
coloumn 2 contains only time stamp ...output should be as standard timestamp .
coloumn 3 contains only date ...output should be as standard timestamp .
output file should contain format as below:
column1 column2 column3
2009-02-28 08:03:00 2009-02-28 08:03:00 2009-02-28 00:00:00
2009-03-28 06:03:00 2009-03-28 08:03:00 2009-03-28 00:00:00
2009-04-08 04:03:00 2009-04-08 08:03:00 2009-04-08 00:00:00
2009-02-09 08:03:00 2009-02-09 08:03:00 2009-02-09 00:00:00
thanks
PRakash
Last edited by dprakash; 04-14-2009 at 11:47 AM..
Reason: formatting
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file containing timestamp( Example given below). How can i get date(mmd-dd-yyyy) from it?
($> cat file1.txt
2008-11-24 05:17:00.7043)
Thanks,
Sri (2 Replies)
Discussion started by: srilaxmi
2 Replies
2. Shell Programming and Scripting
Hi,
I have searched, read and tried, but no luck.
I have this code:
#!/bin/perl -w #-d
use strict;
use POSIX qw(strftime);
my $getprpw_list="/usr/lbin/getprpw -l";
my $host = "nbsol151";
my $user = "genadmin";
my %uid;
my %spwchg;
my %upwchg;
my %slogint; (2 Replies)
Discussion started by: ejdv
2 Replies
3. Programming
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
4. AIX
Can anyone provide me with a ksh or bash script which will accept a timestamp (format is YYYY-MM-DD-HH24.Mi.Ss) and time offset (in hours). The output will be (timestamp passed - time offset passed deducted from it) in the same YYYY-MM-DD-HH24.Mi.Ss format.
Basically I am trying to convert the... (1 Reply)
Discussion started by: shibajighosh
1 Replies
5. UNIX for Dummies Questions & Answers
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
6. Shell Programming and Scripting
Hi,
I have a file as below
I need to overwrite the 2 nd column alone to numeric format like "06122011030414012345" as per the timestamp value
output file should be
the microseconds can be neglected if required.
Any help will be appreciated.
Thanks in advance (1 Reply)
Discussion started by: irudayaraj
1 Replies
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
Hi Team,
We have written a perl script to perform the GMT to MST timestamp conversion.
Input: 2013-12-01T05:23:19.374
Output: need the given timestamp in MT (MST/MDT)
#!/usr/bin/perl
use strict;
use warnings;
use Time::Local;
#always gmt
#my $tval = '2013-12-01T05:23:19.374';
... (4 Replies)
Discussion started by: kmanivan82
4 Replies
9. Shell Programming and Scripting
Hello All,
I have a file with many timestamps as in below format & example:
20150130105120
2015-> Year in YYYY
01-> Month in MM
30-> Day in DD
10-> Hour in HH
51-> Minute in mm
20-> Seconds in SS
This is in GMT. I want to convert all these time stamps in GMT+5:30 format..
Can... (4 Replies)
Discussion started by: ailnilanjan
4 Replies
10. Shell Programming and Scripting
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
LEARN ABOUT DEBIAN
bitten-slave
BITTEN-SLAVE(1) User Commands BITTEN-SLAVE(1)
NAME
bitten-slave - Performs a build and sends result to the Bitten master.
SYNOPSIS
bitten-slave [--version] [-h] [--help] [--name=name] [-f file] [--config=file] [-u username] [--user=username] [-p password]
[--password=password] [-d dir] [--work-dir=dir] [--build-dir=build_dir] [-k] [--keep-files] [-s] [--single] [-n] [--dry-run]
[-i seconds] [--interval=seconds] [-l filename] [--log=filename] [-v] [--verbose] [-q] [--quiet] [--dump-reports] [URL] [URLs]
DESCRIPTION
bitten-slave performs a continuous integration build and reports the result back to the bitten-master. Run bitten-slave --help for details.
COPYRIGHT
Copyright 2009 W. Martin Borgert. Redistribution and use in source and binary forms, with or without modification, are permitted under the
terms of the BSD License.
AUTHOR
W. Martin Borgert
Author.
COPYRIGHT
Copyright (C) 2009 W. Martin Borgert
bitten-slave 2009-10-16 BITTEN-SLAVE(1)