Login or Register to Ask a Question and Join Our Community


AIX

How to manipulate date format?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX How to manipulate date format?
# 1  
Old 06-27-2011
How to manipulate date format?
Hi,

I need to convert the below string in 'yyyymmdd' format.

e.g.,

24 June 2011 -> 20110624

Please help !!
# 2  
Old 06-27-2011
GNU date:
Code:
% date -d'24 June 2011' +%Y%m%d
20110624

# 3  
Old 06-27-2011
in my machine , date -d option is not available

use the below line to convert and it applies for other months also.

echo "24 June 2011" | awk ' { if ( $2~/June/ ) { print $3"06"$1 } } '
# 4  
Old 06-27-2011
this command will work for any date and any month

Code:
 
bash-3.00$ echo "24 June 2011" | nawk ' { months="  JanFebMarAprMayJunJulAugSepOctNovDec";date=$1;month=index(months,substr($2,1,3))/3;year=$3; printf("%s%02s%02s\n",year,month,date)}'
20110624

bash-3.00$ echo "10 June 2011" | nawk ' { months="  JanFebMarAprMayJunJulAugSepOctNovDec";date=$1;month=index(months,substr($2,1,3))/3;year=$3; printf("%s%02s%02s\n",year,month,date)}'
20110610

bash-3.00$ echo "1 November 2011" | nawk ' { months="  JanFebMarAprMayJunJulAugSepOctNovDec";date=$1;month=index(months,substr($2,1,3))/3;year=$3; printf("%
s%02s%02s\n",year,month,date)}'
20111101

# 5  
Old 06-27-2011
A good throw kamaraj.. Really good ..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date: invalid date trying to set Linux date in specific format

i try to set linux date & time in specific format but it keep giving me error Example : date "+%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" or date +"%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" keep giving me this error : date: invalid date ‘19-01-2017 00:05:01' Please use CODE tags... (7 Replies)
Discussion started by: umen
7 Replies

2. UNIX for Dummies Questions & Answers

Rename all Files in a UNIX Directory from one date format to another date format

Hi Unix Gurus, I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Discussion started by: pchegoor
1 Replies

3. Solaris

How to Manipulate Date based on number of days?

I have script where in i issue a command to get back 6 month earlier date. below command works on all linux distribution. # date +%Y-%m-%d --date="2012-03-31 - 183 days ago" 2011-09-30 Is there any solaris equivalent command to do the same? (1 Reply)
Discussion started by: pinga123
1 Replies

4. Shell Programming and Scripting

finding date numeral from file and check the validity of date format

hi there I have file names in different format as below triss_20111117_fxcb.csv triss_fxcb_20111117.csv xpnl_hypo_reu_miplvdone_11172011.csv xpnl_hypo_reu_miplvdone_11-17-2011.csv xpnl_hypo_reu_miplvdone_20111117.csv xpnl_hypo_reu_miplvdone_20111117xfb.csv... (10 Replies)
Discussion started by: manas_ranjan
10 Replies

5. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies

6. Shell Programming and Scripting

manipulate & format the output of spool command

Hi All, I am spooling the data some sql queries into a single file but wanted to know how to format the data of the file generated by spool. #!/bin/sh unset -f USAGE USAGE () { clear echo "############################USAGE#######################\n" echo "Incorrect number of... (2 Replies)
Discussion started by: ss_ss
2 Replies

7. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies

8. Shell Programming and Scripting

manipulate data with specific format

Hi everybody: I have a problem with how I have to manipulate the data which have specific format like this: 249. 0.30727021E+05 0.30601627E+05 0.37470780E-01 -0.44745335E+02 0.82674536E+03 248. 0.30428182E+05 0.30302787E+05 0.40564921E-01 -0.45210293E+02 ... (5 Replies)
Discussion started by: tonet
5 Replies

9. Shell Programming and Scripting

convert mmddyy date format to ccyyddd format??

hi, for reading a cobol indexed file i need to convert "mmddyy" date format to "ccyyddd" format. i checked the datecalc and other scripts but couldnt modify them to cater to my need:(... The datecalc gives an output which i believe is the total days till that date, but i want to convert it... (2 Replies)
Discussion started by: Bhups
2 Replies

10. Shell Programming and Scripting

How to manipulate date?

Hi can u pls help me out with this as i am relatively new to unix. I need to use 4 different types of dates in my shell script * first day of the last(previous) month * last day of the last(previous) month * first day of the current month * (sysdate-1) yesterday's date for the current... (5 Replies)
Discussion started by: phani
5 Replies
Login or Register to Ask a Question