Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Date Conversion on output string from awk
Top Forums UNIX for Advanced & Expert Users Date Conversion on output string from awk Post 302445770 by agama on Monday 16th of August 2010 11:11:05 PM
Old 08-17-2010
If you don't have to worry about portability, and the date command installed on your system supports the -d option, this will work:

Code:
date -d "May 24 2010"  "+%Y/%m/%d"

You can incorporate that with your awk programme to convert your string. I'm not a POSIX expert, but I am fairly certain that this is notstandard at all, so go with caution if you decide on this route.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

String Conversion in awk

I am porting a awk script from Windows to unix I_SALE_MEDIA=$67 if ((I_VOID_FLAG == "Y") && (I_SALE_MEDIA == 0)) NOW consider the case where I_SALE_MEDIA i.e $67 is "000" The above comparison works fine in Windows , but to make it work in Unix , I had to change the above as follows : ... (3 Replies)
Discussion started by: rohanrege
3 Replies

2. Shell Programming and Scripting

awk script for date conversion

hi awk script for dd/mm/yyyy to yyyymmdd awk script for dd-mon-yyyy to yyyymmdd awk script for dd-mm-yyyy to yyyymmdd formate ..............urgent............. Thanks in advanced (2 Replies)
Discussion started by: charandevu
2 Replies

3. Shell Programming and Scripting

Conversion of Exponential to numeric in awk- not correct output

Hi All, I have 1 million records file. Using awk, I am counting the number of records. But as the number is huge, after crossing a number, awk is displaying it in exponential format. At the end, I need to verify this count given by awk with expected count. But as it is in exponential format,... (3 Replies)
Discussion started by: ssunda6
3 Replies

4. Shell Programming and Scripting

Date string conversion within a file

Hi, I have a log file that contains information along the lines of the following: ========= jobnumber 322761 start_time Tue May 19 19:42:37 2009 end_time Tue May 19 20:11:28 2009 failed 0 ========= jobnumber 322762 start_time Tue May 19 19:39:51 2009 end_time ... (4 Replies)
Discussion started by: chrissycc
4 Replies

5. Shell Programming and Scripting

awk: round output or delimit output of arithmatic string

I have a file with the following content. > cat /tmp/internetusage.txt 6709.296322 30000 2/7/2010 0.00I am using the following awk command to calculate a percentage from field 1 and 2 from the file. awk '{ print $1/$2*100 }' /tmp/internetusage.txt This outputs the value "22.3643" as a... (1 Reply)
Discussion started by: jelloir
1 Replies

6. Shell Programming and Scripting

Date command output conversion

hi all, i need to measure time difference between the time a process started, to the time it ended. i am assuming the following are the steps: 1. output 'date' command at start time 2. output 'date' command at end time 3. subtract the two question is, how do i subtract the two time... (4 Replies)
Discussion started by: rathajs
4 Replies

7. Shell Programming and Scripting

awk string to number conversion

Can someone explain whats happening here: $ awk 'BEGIN {print (2.5 - 1)}' 1,5 2.5 - 1 is correctly calculated to 1,5 (using european locale) $ echo "2.5" | awk '{temp = $1 - 1; print temp}' 1 If i now pipe the string 2.5 through awk it seems at it truncates 2.5 to 2? What's the... (4 Replies)
Discussion started by: beow
4 Replies

8. Shell Programming and Scripting

Most vexing: Sed or Awk scripting for date conversion needed

Hi, I have some files being sent to me that have dates in them in this format: from 1/8/2011 15:14:20 and I need the dates in this format (mysql date format) To 2011-01-08 15:14:20 all I have so far is the regexp that detects the format: sed -r -e 's@\1/\2/\3\4\5\6]::$@do... (7 Replies)
Discussion started by: Astrocloud
7 Replies

9. Shell Programming and Scripting

String to Date conversion

Hi, I have a String say 20131224 which represents a date. I want to to subtract 1 day from this. Any idea how can i do this on AIX. (1 Reply)
Discussion started by: RahulM
1 Replies

10. UNIX for Beginners Questions & Answers

Date format conversion how to change this from using nawk to awk

Hi, I have a file where I need to change the date format on the nth field from DD-MM-YYYY to YYYY-MM-DD so I can accurately sort the record by dates From regex - Use sed or awk to fix date format - Stack Overflow, I found an example using nawk. Test run as below: $: cat xyz.txt A ... (2 Replies)
Discussion started by: newbie_01
2 Replies

LEARN ABOUT SUSE

convdate

CONVDATE(1)						    InterNetNews Documentation						       CONVDATE(1)

NAME

       convdate - Convert to/from RFC 5322 dates and seconds since epoch

SYNOPSIS

       convdate [-dhl] [-c | -n | -s] [date ...]

DESCRIPTION

       convdate translates the date/time strings given on the command line, outputting the results one to a line.  The input can either be a date
       in RFC 5322 format (accepting the variations on that format that innd(8) is willing to accept), or the number of seconds since epoch (if -c
       is given).  The output is either ctime(3) results, the number of seconds since epoch, or a Usenet Date: header, depending on the options
       given.

       If date is not given, convdate outputs the current date.

OPTIONS

       -c  Each argument is taken to be the number of seconds since epoch (a time_t) rather than a date.

       -d  Output a valid Usenet Date: header instead of the results of ctime(3) for each date given on the command line.  This is useful for
	   testing the algorithm used to generate Date: headers for local posts.  Normally, the date will be in UTC, but see the -l option.

       -h  Print usage information and exit.

       -l  Only makes sense in combination with -d.  If given, Date: headers generated will use the local time zone instead of UTC.

       -n  Rather than outputting the results of ctime(3) or a Date: header, output each date given as the number of seconds since epoch (a
	   time_t).  This option doesn't make sense in combination with -d.

       -s  Pass each given date to the RFC 5322 date parser and print the results of ctime(3) (or a Date: header if -d is given).  This is the
	   default behavior.

EXAMPLES

       Most of these examples are taken, with modifications from the original man page dating from 1991 and were run in the EST/EDT time zone.

	   % convdate '10 Feb 1991 10:00:00 -0500'
	   Sun Feb 10 10:00:00 1991

	   % convdate '13 Dec 91 12:00 EST' '04 May 1990 0:0:0'
	   Fri Dec 13 12:00:00 1991
	   Fri May  4 00:00:00 1990

	   % convdate -n '10 feb 1991 10:00' '4 May 90 12:00'
	   666198000
	   641880000

	   % convdate -c 666198000
	   Sun Feb 10 10:00:00 1991

       ctime(3) results are in the local time zone.  Compare to:

	   % convdate -dc 666198000
	   Sun, 10 Feb 1991 15:00:00 +0000 (UTC)

	   % env TZ=PST8PDT convdate -dlc 666198000
	   Sun, 10 Feb 1991 07:00:00 -0800 (PST)

	   % env TZ=EST5EDT convdate -dlc 666198000
	   Sun, 10 Feb 1991 10:00:00 -0500 (EST)

       The system library functions generally use the environment variable TZ to determine (or at least override) the local time zone.

HISTORY

       Written by Rich $alz <rsalz@uunet.uu.net>, rewritten and updated by Russ Allbery <rra@stanford.edu> for the -d and -l flags.

       $Id: convdate.pod 8894 2010-01-17 13:04:04Z iulius $

SEE ALSO

       active.times(5).

INN 2.5.2							    2010-02-08							       CONVDATE(1)
All times are GMT -4. The time now is 10:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy