Date Format


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date Format
# 1  
Old 12-30-2011
Date Format

Hello friends,

I have one question regarding the change of date format since I am new to shell scripting please help me by giving your precious time ....


Q: I want to change the format of date from 1-Nov-2011 and change this format into 1-11-2011 please help me regarding this . It will be a great help for the people like me who is new to this field.

Your support will be appreciated.

I have used this
Code:
echo 1-Nov-2011 | sed "s/\(.\{4\}\)\(..\)\(..\)\(..\)\(..\)\(..\)/\3-\2-\1 \4:\5:\6/"

Thanks

Last edited by Franklin52; 12-30-2011 at 09:00 AM.. Reason: Please use code tags for data and code samples, thank you
# 2  
Old 12-30-2011
Try this...
Code:
date -d "1-Nov-2011" '+%d-%m-%Y'

--ahamed
# 3  
Old 12-30-2011
Hi ahamed,

Thanx a lot friend for helping me it is a command can you tell me the proper scipt because i don't know it will be a great help.

---------- Post updated at 07:59 AM ---------- Previous update was at 07:39 AM ----------

Hi ahamed,

It is showing date -d and it is showing -d as illegal operation.
# 4  
Old 12-30-2011
Code:
echo "1-Nov-2011" | awk -F"-" 'BEGIN{ a["Jan"]=1;a["Feb"]=2;a["Nov"]=11;a["Dec"]=12 }{ print $1 OFS a[$2] OFS $3 }' OFS="-"

Of course, fill the remaining months...

If Solaris, use nawk

--ahamed
# 5  
Old 12-30-2011
A Shell way: Adjust according to whether you wanted a leading zero on the month number or not.

Code:
ddmmmyy="1-Nov-2011"
dd=`echo "${ddmmmyy}"|cut -f1 -d\-`
mmm=`echo "${ddmmmyy}"|cut -f2 -d\-`
yy=`echo "${ddmmmyy}"|cut -f3 -d\-`
echo "dd=${dd}  mmm=${mmm}  yy=${yy}"
#
case "${mmm}" in
        "Jan")  mm="1" ;;
        "Feb")  mm="2" ;;
        "Mar")  mm="3" ;;
        "Apr")  mm="4" ;;
        "May")  mm="5" ;;
        "Jun")  mm="6" ;;
        "Jul")  mm="7" ;;
        "Aug")  mm="8" ;;
        "Sep")  mm="9" ;;
        "Oct")  mm="10" ;;
        "Nov")  mm="11" ;;
        "Dec")  mm="12" ;;
esac
echo "dd=${dd}  mm=${mm}  yy=${yy}"
echo "${dd}-${mm}-${yy}"

./scriptname
dd=1  mmm=Nov  yy=2011
dd=1  mm=11  yy=2011
1-11-2011


Last edited by methyl; 12-30-2011 at 01:29 PM.. Reason: mispasted
# 6  
Old 12-30-2011
Code:
date '+%d-%m-%Y'


Last edited by radoulov; 12-30-2011 at 04:36 PM.. Reason: Code tags!
# 7  
Old 12-31-2011
Code:
$ echo "1-Nov-2011" | awk -F- 'BEGIN{a="  JanFebMarAprMayJunJulAugSepOctNovDec"}{printf("%s-%s-%s",$1,index(a,$2)/3,$3)}'
1-11-2011

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

4. UNIX for Dummies Questions & Answers

Shell Scripts - shows today’s date and time in a better format than ‘date’ (Uses positional paramete

Hello, I am trying to show today's date and time in a better format than ‘date' (Using positional parameters). I found a command mktime and am wondering if this is the best command to use or will this also show me the time elapse since 1/30/70? Any help would be greatly appreciated, Thanks... (3 Replies)
Discussion started by: citizencro
3 Replies

5. Shell Programming and Scripting

Date after 5 days from current date in YYYYMMDD format

Hello Experts, How do i get date after 5 days from current date in YYYYMMDD format? How do you compare date in YYYYMMDD format? Thanks (8 Replies)
Discussion started by: needyourhelp10
8 Replies

6. Shell Programming and Scripting

How to increment a user defined date value in the DATE format itself using shell script?

I need to increment a date value through shell script. Input value consist of start date and end date in DATE format of unix. For eg. I need increment a date value of 1/1/09 to 31/12/09 i.e for a whole yr. The output must look like 1/1/09 2/2/09 . . . 31/1/09 . . 1/2/09 . 28/2/09... (1 Reply)
Discussion started by: sunil087
1 Replies

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

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

9. UNIX for Advanced & Expert Users

date issue-find prevoius date in a patricular format

Hi , I have written a shell script that takes the current date on the server and stores it in a file. echo get /usr/home/data-`date '+%Y%d'`.xml> /usr/local/sandeep/GetFILE.ini I call this GetFILE.ini file from an sftp program to fetch a file from /usr/home/ as location. The file is in... (3 Replies)
Discussion started by: bsandeep_80
3 Replies

10. 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
Login or Register to Ask a Question