05-11-2015
Date format from Jan 01 2015 11:00:00 PM to 01/01/2015 23.00.00
I need to change Date and time stamp format from Jan 01 2015 11:00:00 PM to 01/01/2015 23.00.00
Existing Format : Mon DD YYYY hh:mi:ss AM/PM (Jan 01 2015 11:00:00 PM)
Expected Format: MM/DD/YYYY hh.mi.ss 24 hours (01/01/2015 23.00.00)
I need to update enitire file where used date and time.
File size is more than 2 gb and have 10 millon records in file.
Unix vesrion : AIX
Appreciate any help that you can provide.
Last edited by Don Cragun; 05-11-2015 at 04:08 AM..
Reason: Add ICODE tags.
6 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have the following perl one-liner to get yesterday's date, but I would like it in the form of dd-MMM-yy (for example: 01-JAN-12). Can someone alter the below code so I get the format I want? Also, could someone also give me a line for dd-Mmm-yy (for example 01-Jan-12)?
Code:
YEST=`perl -w... (3 Replies)
Discussion started by: thibodc
3 Replies
2. Shell Programming and Scripting
How to convert date format such as 7/18/2015 to the number of month from requesting date 'date' in sh scripting ?
Let say I have output in my log.txt -> 7/18/2015. How I convert it to the full number of month starting from 'date' till 7/18/2015 in shell scripting ? Thanks in advance. (1 Reply)
Discussion started by: amerabest
1 Replies
3. What is on Your Mind?
http://i62.tinypic.com/zt6a08.jpg (2 Replies)
Discussion started by: ongoto
2 Replies
4. Solaris
I hear the Leap second for 2015 will occur on June 30 at 23:59:60 according to the wild rumours from internet the expected impact ranges from crashing to hanging servers.
Can anybody share their preparations what they have done for solaris servers? are there any patches to install or workaround?... (1 Reply)
Discussion started by: sparcguy
1 Replies
5. What is on Your Mind?
Only a little over a week until I head out to LinuxCon in Seattle. Anyone else attending this year? (0 Replies)
Discussion started by: Gallavin
0 Replies
6. SCO
Dear friends,
i am having some Problems with a Sco Openserver in a Box (normally on VMWare, importing it on a Virtualbox does the same).
When i boot up the system on xx/09/2015 i got fork failed - too many processes during startup.
The programs which should run on the server, do not run.
I... (67 Replies)
Discussion started by: ChipperEs
67 Replies
LEARN ABOUT CENTOS
dm_date
DM_DATE(1) User Contributed Perl Documentation DM_DATE(1)
NAME
dm_date - print out the system date and time
SYNOPSIS
This performs the same operation as the unix 'date' command, but using the Date::Manip module.
dm_date [OPTION]... [+FORMAT]
DESCRIPTION
This displays information about the current system time, or some other time. Options are:
-h, --help
Print online help.
-d STRING, --date=STRING
Display time described by STRING. STRING can be any string which can be parsed by Date::Manip. Please refer to the Date::Manip::Date
documentation for details.
-f DATEFILE, --file=DATEFILE
This reads each line in DATEFILE, and extracts a date from it and prints out the information.
Blank lines and lines starting with a pound (#) are ignored. Lines not containing a valid date are also ignored.
-r FILE, --reference=FILE
Displays the last modification time of FILE.
-R, --rfc-2822
Displayc the date and time in RFC 2822 format.
Example: Mon, 07 Aug 2006 12:34:56 -0600
-u, --utc, --universal
Converts the date to UT (GMT) and prints out the information.
Only one of -d, -f, or -r should be included. If more than one is included, the first one from the list (-d, -f, -r) is used and any other
is ignored.
The format string starts with a plus (+) and contains any of the format directives described in Date::Manip::Date.
KNOWN BUGS
None known.
BUGS AND QUESTIONS
Please refer to the Date::Manip::Problems documentation for information on submitting bug reports or questions to the author.
SEE ALSO
Date::Manip::Date
LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
AUTHOR
Sullivan Beck (sbeck@cpan.org)
perl v5.16.3 2014-06-09 DM_DATE(1)