Date format change in AIX


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Date format change in AIX
# 1  
Old 04-07-2016
Date format change in AIX

Hi I have a date format in a variable as Apr 7 03:35:59 EDT 2016. how do i change it to 04/07/2016 03:35:59 EDT format

Last edited by sushma123; 04-07-2016 at 10:22 AM.. Reason: changed to icode as no code -
# 2  
Old 04-07-2016
Hi,

You don't say how you source the variable, however you can try;

Code:
date '%m/%d/%y %H:%M:%S'

The information is in the man pages, use man date and you should find what you want.

Regards

Gull04
# 3  
Old 04-07-2016
Quote:
Originally Posted by gull04
Hi,

You don't say how you source the variable, however you can try;

Code:
date '%m/%d/%y %H:%M:%S'

The information is in the man pages, use man date and you should find what you want.

Regards

Gull04
The format requested if the user is trying to format the current date and time is:
Code:
date '+%m/%d/%Y %H:%M:%S %Z'

(note the leading + required to specify that a format string follows, %Y instead of %y (complete year, not just the last two digits) and %Z (include the timezone name).

If the intent is to take an existing date and time in the first given format and convert it to the corresponding second given format, there is no way to guess at what year should be used for an arbitrary date and time from some point in the past.
# 4  
Old 04-07-2016
Source of variable is taken from log file. So I need to format variable later. I am working in AIX . Not finding Gnu date
# 5  
Old 04-07-2016
As Don said, there's no way to guess the year (unless you know the date is within a specific time window e.g. no more than 300 days in the past).

There are some date scripts in the FAQ and Tips forums.
# 6  
Old 04-07-2016
I have missed 2016 in end
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Change Date from one format to other

Hi I wish to change date from one format to another in unix. eg: INPUT DATE: 2013159 (YEAR & NUMBER OF DAY) OUTPUT DATE required: 20130608 (YYYYMMDD) how to do it ? Thanks in advance. (6 Replies)
Discussion started by: dashing201
6 Replies

2. Shell Programming and Scripting

Change the date format

Hi, I was looking for a script to change the date from one format to other. A search in the forum gave me the below script as a result. #! /bin/ksh format=YYYYMMDD YEAR=${format%????} DAY=${format#??????} MON=${format#$YEAR} MON=${MON%$DAY} echo $MON/$DAY/$YEAR I got it... (2 Replies)
Discussion started by: prithvirao17
2 Replies

3. Shell Programming and Scripting

Change the date format

Hi all, I have a file that every line starts with the date and time. The format is like YYYYMMDDHHMM and I woulk like to change it to MM/DD/YY<space>HH:MM. I tried to figure out a way to do it with sed, but I don't know how I could reorganize the digits of the first format. Does anyone have any... (1 Reply)
Discussion started by: geovas
1 Replies

4. Shell Programming and Scripting

Date format change

Dear Friends, Need your help once again, I have a variable ( e.g. ${i}) whoch has date in MM/DD/YYYY (E.g. 12/31/2011) format. I want to change it to DD/MM/YYYY (e.g. 31/12/2011) format. Request you to guide me as we are unable to do the same. Thanks in advance Anu. (1 Reply)
Discussion started by: anushree.a
1 Replies

5. Shell Programming and Scripting

How to change the date format

Hi Guys, Can someone help me on how to change the date format using sed or any unix command to give my desired output as shown below. INPUT FILE: 69372,200,20100122T17:56:02,2 53329,500,20100121T11:50:07,2 48865,100,20100114T16:08:16,2 11719,200,20100108T13:32:20,2 DESIRED... (2 Replies)
Discussion started by: pinpe
2 Replies

6. Shell Programming and Scripting

Change Date Format

Hi Guys, I had a scenario like this.. It seems very silly...dont think it as a home work question.....:) i tried it many ways but i didn't achieve this... start_date=May122011 here i want to change the start_date in to 20110512 start_date=20110512 tell me how can we achive... (5 Replies)
Discussion started by: apple2685
5 Replies

7. Shell Programming and Scripting

Date Format Change

Hi I have a date format in a variable as Mon Jan 11 03:35:59 2010. how do i change it to YYYYMMDD format (3 Replies)
Discussion started by: keerthan
3 Replies

8. Solaris

change date format

dear members, ls -l drwxr-xr-x 40 root sys 1024 Jul 11 22:19 usr drwxr-xr-x 43 root sys 1024 Feb 1 2009 var i am using solaris 10 is that possibe to do drwxr-xr-x 40 root sys 1024 25-08-2009 22:19 usr drwxr-xr-x 43 root sys ... (4 Replies)
Discussion started by: hosney00ux
4 Replies

9. Shell Programming and Scripting

How to Change the Format of a Date

Hi All, this is my second post, last post reply was very helpful. I have a data that has date in DD/MM/YYYY (07/11/2008) format i want to replace the backslash by a dot(.) so that my awk script can read it inside the C shell script that i have written. i want to change 07/11/2008 to... (3 Replies)
Discussion started by: asirohi
3 Replies

10. UNIX for Advanced & Expert Users

Change date format

I know the command date +"%Y%m%d" can change today's date to digit format as below . $date +"%Y%m%d" 20071217 it works fine . now I want to do it back . If I have a file like below, (in the file , there are three lines, and each line have ; sign , after the ; sign is the date ) , I... (4 Replies)
Discussion started by: ust
4 Replies
Login or Register to Ask a Question