Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Military type format date/time conversion
Top Forums Shell Programming and Scripting Military type format date/time conversion Post 302571911 by jambesh on Tuesday 8th of November 2011 02:43:03 PM
Old 11-08-2011
Military type format date/time conversion
Hello All,

I have a requirement to convert a 12 hour format to 24 hour time format and the sample input /out put is below

Input Time format : Nov 2 2011 12:16AM
Out Put Format : Nov 2 2011 0:16

Input : Nov 2 2011 4:16PM
Out Put: Nov 2 2011 16:16

I have done this using a perl script and working absolutely fine -
###############
Code:
use strict;

while( my $line = <DATA> ){
 $line =~ s/(\d+)(:\d+)(A|P)\.M\,/($3 eq 'a')?($1%12).$2:($1%12+12).$2/e;
 print $line;
}

__DATA__
Nov 2 2011 12:41A.M,
Nov 2 2011 12:41A.M,
Nov 2 2011  3:41P.M,
Nov 2 2011  5:41P.M,

###################OUT PUT#############

Nov 2 2011 12:41
Nov 2 2011 12:41
Nov 2 2011 15:41
Nov 2 2011 17:41


My requirement is now :
1) I have file with thousands of records like below and i want to convert each of the records with right time format as i mentioned above.

Nov 2 2011 12:01AM,52893,420,1,4,0,52834,4,1208,67664942,603459924403.0,1,150054,1208,3
Nov 2 2011 5:16PM,52127,420,1,4,0,52122,4,1429,55943831,603459924406.0,1,150054,1429,3

I need to convert the first column match (12:01AM/5:16PM) and convert this to right format

Expected output is :

Nov 2 2011 0:01,52893,420,1,4,0,52834,4,1208,67664942,603459924403.0,1,150054,1208,3
Nov 2 2011 17:16,52127,420,1,4,0,52122,4,1429,55943831,603459924406.0,1,150054,1429,3

I know with little modification to my script this can be acheived but i am not able to match the entire record with regx.

ANY HELP IS MUCH APPRICIATED.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Date format conversion function

Hello, does somebody knows about a function that would convert a date like: YYMMDD into a date like YYYY-MM-DD ? Thank you for your ideas :) (9 Replies)
Discussion started by: Cecile
9 Replies

2. Windows & DOS: Issues & Discussions

conversion of unix time format

help me to convert unix time format into windows time format using java i have linux time ex. 1075329297.572 (2 Replies)
Discussion started by: sari
2 Replies

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

4. UNIX for Dummies Questions & Answers

date format conversion

hi, i have a file in which i get date format as 22/APR/2010... now i want the date format to be in 22-04-2010 if the month changes to may the file should also have 05 as month.... pls help (3 Replies)
Discussion started by: siva_nagarajan
3 Replies

5. Shell Programming and Scripting

Date format conversion

Hi All, Can someone please let me know how can i convert the date format in unix as follow: From: 24 Oct 2011 i.e $(date +'%d %b %Y') To: 111024 i.e $(date +%y%m%d) Thanks in advance (3 Replies)
Discussion started by: davidtd
3 Replies

6. Shell Programming and Scripting

Date conversion from 24 hr format to 12 hr format

hi i want to convert date procured from sone operation which will be in 24hr format to 12 hr format displaying AM and PM # date -d @1362545068 Tue Mar 5 23:44:28 EST 2013 # this Tue Mar 5 23:44:28 EST 2013 i want to convert it so that output is as below Tue... (2 Replies)
Discussion started by: vivek d r
2 Replies

7. Shell Programming and Scripting

Date conversion and Format

Hello , I have a record in below format Hostname | Query: 0 | Release: 0 | files: 2 | Files_examined: 2 | SET timestamp=1396778638; | select * from test I need output in below format Hostname | 0 | 0 | 2 | 2 | 04/06/2014|03:03:58 | select * from test I was able to get above output... (1 Reply)
Discussion started by: Tomlight
1 Replies

8. Shell Programming and Scripting

Date format conversion

Hi, i have to check the file whether it is created today. here is the ls -l o/p -rw-r----- 20000 50000 130 Dec 12 10:21 file.txt im able to check if file is created today or not if the timestamp is in 2014-12-12 format by comparing $(date +Y-%m-%d) but stuckup as it is of format Dec 12... (6 Replies)
Discussion started by: JSKOBS
6 Replies

9. Shell Programming and Scripting

Bash Scripting with date format conversion

I have a script below and wanted to change the output into three different file format (3 separate script) #!bin/bash #input file format postwrf_d01_20131206_0600_f08400.grb2 #postwrf_d01_YYYYMMDD_ZZZZ_f0HHHH.grb2 #zzzz= 0000,0600,1200,1800 (in UTC) #HHHH=00000,00600,01200,01800 ..ect (in... (1 Reply)
Discussion started by: cumulus_255
1 Replies

10. UNIX for Beginners Questions & Answers

Date format conversion how to change this from using nawk to awk

Hi, I have a file where I need to change the date format on the nth field from DD-MM-YYYY to YYYY-MM-DD so I can accurately sort the record by dates From regex - Use sed or awk to fix date format - Stack Overflow, I found an example using nawk. Test run as below: $: cat xyz.txt A ... (2 Replies)
Discussion started by: newbie_01
2 Replies

LEARN ABOUT DEBIAN

mojo::date

Mojo::Date(3pm) 					User Contributed Perl Documentation					   Mojo::Date(3pm)

NAME

       Mojo::Date - HTTP 1.1 date container

SYNOPSIS

	 use Mojo::Date;

	 my $date = Mojo::Date->new(784111777);
	 my $http_date = $date->to_string;
	 $date->parse('Sun, 06 Nov 1994 08:49:37 GMT');
	 my $epoch = $date->epoch;

DESCRIPTION

       Mojo::Date implements HTTP 1.1 date and time functions according to RFC 2616.

	 Sun, 06 Nov 1994 08:49:37 GMT	; RFC 822, updated by RFC 1123
	 Sunday, 06-Nov-94 08:49:37 GMT ; RFC 850, obsoleted by RFC 1036
	 Sun Nov  6 08:49:37 1994	; ANSI C's asctime() format

ATTRIBUTES

       Mojo::Date implements the following attributes.

   "epoch"
	 my $epoch = $date->epoch;
	 $date	   = $date->epoch(784111777);

       Epoch seconds.

METHODS

       Mojo::Date inherits all methods from Mojo::Base and implements the following new ones.

   "new"
	 my $date = Mojo::Date->new;
	 my $date = Mojo::Date->new($string);

       Construct a new Mojo::Date object.

   "parse"
	 $date = $date->parse('Sun Nov	6 08:49:37 1994');

       Parse date in one of the following formats.

	 - Epoch format(784111777)
	 - RFC 822/1123 (Sun, 06 Nov 1994 08:49:37 GMT)
	 - RFC 850/1036 (Sunday, 06-Nov-94 08:49:37 GMT)
	 - ANSI C asctime() (Sun Nov  6 08:49:37 1994)

   "to_string"
	 my $string = $date->to_string;

       Render date suitable for HTTP 1.1 messages.

SEE ALSO

       Mojolicious, Mojolicious::Guides, <http://mojolicio.us>.

perl v5.14.2							    2012-09-05							   Mojo::Date(3pm)
All times are GMT -4. The time now is 04:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy