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 03-12-2009
date formatting
Hi

i need to have the date in the format like dd-mon-yyyy

my script goes like this
Code:
#!/usr/bin/bash
for f in /space/can /home/lbs/current/externalcdrbackup/L_CDR_Configuration/1/200903122* ; do
awk '{sum[$4]++;}END{for(i in sum) {print d,h,m,i, sum[i]}}' "d=$(date +'%m-%d-%Y')" "h=$(date +'%H')" "m=$(date +'%M')" $f > /aemu/
cdr_events.txt
done;

i am not able to load the date field in the oracle DB if i use the above format.
i need it to be 12-mar-2009

am i correct in loading the hour and minute in separate column...

one more thing in the hour value i need to reduce one hour while printing to the file where it is stored...
Quote:
12-mar-2009 23 (i want 22 hours in place of actual 23) 38 BSNLSERVICE1 86
how to reduce the hour by one hour?

thanks
Aemunathan
# 2  
Old 03-12-2009
Code:
#date  +'%H' --date="1 hour ago"
11

# date +'%d-%b-%Y'
12-Mar-2009

EDIT: This is assuming your using GNU date.
Last edited by Ikon; 03-12-2009 at 04:36 PM..
# 3  
Old 03-12-2009

Code:
#!/usr/bin/bash
for f in /space/can /home/lbs/current/externalcdrbackup/L_CDR_Configuration/1/200903122* ; do
  eval "$(date +' d=%m-%b-%Y h=%H m=%M')"
  awk -v d=$d -v h=$(( $h - 1 )) -v m=$m '{sum[$4]++}
   END {for(i in sum) {print d,h,m,i, sum[i]}}' "$f" > /aemu/cdr_events.txt
done;

Last edited by vgersh99; 03-12-2009 at 04:42 PM.. Reason: missing trailing '
# 4  
Old 03-13-2009
hi

am getting the error

Quote:
awk: syntax error near line 1
awk: bailing out near line 1
# 5  
Old 03-13-2009

If you are on Solaris, always use nawk or /usr/xpg4/bin/awk.
# 6  
Old 03-13-2009
hi
am getting error

/usr/xpg4/bin/awk: syntax error Context is:
>>> ./ <<<
# 7  
Old 03-13-2009
Quote:
Originally Posted by aemunathan
hi
am getting error

/usr/xpg4/bin/awk: syntax error Context is:
>>> ./ <<<
Post exactly what you've tried using code Tags.
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

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

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

9. Shell Programming and Scripting

date formatting

Date format MM/DD/YYYY required is YYYYMMDD, I tried using sed but could not get it any help please. (4 Replies)
Discussion started by: mgirinath
4 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