Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

date formatting

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting date formatting
# 1  
Old 07-07-2006
date formatting
Date format MM/DD/YYYY
required is YYYYMMDD, I tried using sed but could not get it any help please.
# 2  
Old 07-07-2006
Code:
awk '{print substr($0,7,4) substr($0,1,2) substr($0,4,2)}'

or
Code:
awk 'BEGIN {FS="/"; OFS=""} {print $3,$1,$2}'

Last edited by Glenn Arndt; 07-07-2006 at 05:00 PM..
# 3  
Old 07-07-2006
try:
Code:
#!/bin/ksh

reformat()
{
    echo "$1" | tr -s '/' ' ' | read month day year
    echo "$year""$month""$day"
}

for dt in 01/10/1999 10/01/2000 12/30/2006 
do
	echo "$(reformat "$dt" )"
done

# 4  
Old 07-07-2006
Thanks
that worked Thanks
# 5  
Old 07-08-2006
Quote:
Originally Posted by mgirinath
Date format MM/DD/YYYY
required is YYYYMMDD, I tried using sed but could not get it any help please.
Code:
$ echo MM/DD/YYYY | sed -e 's_^\(.\{2\}\)\/\(.\{2\}\)\/\(.\{4\}\)$_\3\1\2_'
YYYYMMDD

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help in formatting the date taken from a variable

Hi, I am having the below data in input file. The file contains multiple such lines. The file is comma delimited. AAA,M,CCCCCC,EE,DD,FF,GG,1187.00000,01-MAY-05 BBB,M,CCCCCC,EE,DD,FF,GG,87.00000,10-MAY-05 I need to create below output file out of it- <tag1>AAA</tag1>... (3 Replies)
Discussion started by: Arjun_CV
3 Replies

2. UNIX for Dummies Questions & Answers

Need Date Formatting help

Hi, How can i store the date + time from the output of the ls command in loop in a variable date1? -rw-rw---- 1 user1 admin 500002 Jan 2 21:24 P002607.cssI then want to convert Jan 2 21:24 to this date format 2014-01-02 21:24:00 and save it in date2 variable. Then i would like to add... (1 Reply)
Discussion started by: mohtashims
1 Replies

3. Emergency UNIX and Linux Support

DATE TIME formatting

can anyone one help me....to make date and time format...to following format for my file Code: DATE TIME DD- MON- YEAR 24 Hours I have a need of format like this 12-Jan-2012 in one column, then time in 24 Hours in another column....please help...me... ... (7 Replies)
Discussion started by: nex_asp
7 Replies

4. Shell Programming and Scripting

Formatting date

Hi all Y=`date +'%Y'` M=`date +'%m'` D=`date +'%d'` if && ;then yesterday=$Y$M`expr $D + 30` echo $yesterday else if && ; then yesterday=$Y$M`expr $D + 29` echo $yesterday else if ; then yesterday=$Y$M`expr $D + 27` echo $yesterday else yesterday=$Y$M`expr $D - 1` echo... (8 Replies)
Discussion started by: ultimatix
8 Replies

5. Shell Programming and Scripting

Formatting a date

Hi, the date value retrieved by a parameter from the table is of the format dd/mm/yyyy. please let me know how to convert this to YYYYMMDD using sed thanks (4 Replies)
Discussion started by: swasid
4 Replies

6. OS X (Apple)

Date Formatting, etc.

Hi - I'm using GeekTool to customize my desktop in OS X 10.5.8 I'm a complete novice as far as UNIX commands, just know enough to be dangerous. I have a command entered as a Shell to display my events from iCal: This makes my events show something like this: While this is... (1 Reply)
Discussion started by: patricksprague
1 Replies

7. Shell Programming and Scripting

date formatting

Hi i need to have the date in the format like dd-mon-yyyy my script goes like this #!/usr/bin/bash for f in /space/can /home/lbs/current/externalcdrbackup/L_CDR_Configuration/1/200903122* ; do awk '{sum++;}END{for(i in sum) {print d,h,m,i, sum}}' "d=$(date +'%m-%d-%Y')" "h=$(date +'%H')"... (8 Replies)
Discussion started by: aemunathan
8 Replies

8. Shell Programming and Scripting

formatting date in ksh

hi all, in ksh, how do i format date so it includes hour and minute ?? i am trying the following command : date +%Om/%Od/%Oy%OH:%M but it displays the hour and minute concatenated with the day/month/year e.g 12/10/0814:08 when i want the output to be 12/10/08 14:08 i tried... (4 Replies)
Discussion started by: cesarNZ
4 Replies

9. UNIX for Dummies Questions & Answers

Date formatting

Running bash how do I input the date in the command line like 3/20/90 and get an output formmated like March, 20 1990. (8 Replies)
Discussion started by: knc9233
8 Replies

10. Shell Programming and Scripting

Formatting date

i need date in the following format December 14, 2005. With date +"%b %d, %Y" command i am getting the following output :- Dec 14, 2005. can anyone pls tell me how to get the full month name (2 Replies)
Discussion started by: radhika03
2 Replies
Login or Register to Ask a Question