Convert date with awk Post: 302410226

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert Julian date to calender date

Hi, I have script in unix which creates a julian date like 126 or 127 I want convert this julian date into calender date ex : input 127 output 07/may/2007 or 07/05/2007 or 07/05/07 rgds srikanth

2. 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. Shell Programming and Scripting

Awk convert from day of year to date

Hello everyone, I have a file which has day of year in one of the columns (JD=substr($0,72,3)). The bellow scripts shows me the minimum and maximum values of the JD and I would like to convert the JD to date. #!/bin/gawk -f { check=substr($0,1,1) if (check == "S") { ...

4. Shell Programming and Scripting

Using awk or nawk to convert epoch time to date format

Looking for some help and usually when I do a search this site comes up. Hopefully someone can give me a little direction as to how to use one of these two commands to achieve what I'm trying to do. What am I trying to do? I need to take the time value in epoch format returned from the...

5. UNIX for Dummies Questions & Answers

Unable to convert date into no. using date -d +%s syntax in ksh shell

hi friends, I m trying to write a script which compares to dates. for this i am converting dates into no using synatx as below v2=`date | awk '{print $2,$3,$4}'` v3=`date +%s -d "$v2"` this syntax is working in bash shell ,but fails in ksh shell. please suggest on this.

6. Shell Programming and Scripting

awk convert date format

Could you tell me how to convert the following dates? If I have m/d/yyyy, I want to have 0m/0d/yyyy. I want my dates to always be 8 digits. In other words, I want a 0 inserted whenever the month or day is a single digit. My issue is first I need to use FS="," to get field $4 for the...

7. Shell Programming and Scripting

Convert date arg to sql date

Doing a bcp load to sybase and need to convert datearg which comes in as 20130501 to 2013-05-01 which is the best way to do this

8. Shell Programming and Scripting

Convert a date stored in a variable to epoch date

I am not able to pass date stored in a variable as an argument to date command. I get current date value for from_date and to_date #!/usr/bin/ksh set -x for s in server ; do ssh -T $s <<-EOF from_date="12-Jan-2015 12:02:09" to_date="24-Jan-2015 13:02:09" echo \$from_date echo...

9. Shell Programming and Scripting

Sed/awk command to convert number occurances into date format and club a set of lines

Hi, I have been stuck in this requirement where my file contains the below format. 20150812170500846959990854-25383-8.0.0 "ABC Report" hp96880 "4952" 20150812170501846959990854-25383-8.0.0 End of run 20150812060132846959990854-20495-8.0.0 "XYZ Report" vg76452 "1006962188"...

LEARN ABOUT DEBIAN

apr::date

libapache2-mod-perl2-2.0.7::docs::api::APR::Date(3pm)	User Contributed Perl Documentation  libapache2-mod-perl2-2.0.7::docs::api::APR::Date(3pm)

NAME

       APR::Date - Perl API for APR date manipulating functions

Synopsis
	 use APR::Date ();

	 # parse HTTP-complient date string
	 $date_string = 'Sun, 06 Nov 1994 08:49:37 GMT';
	 $date_parsed = APR::Date::parse_http($date_string);

	 # parse RFC822-complient date string
	 $date_string = 'Sun, 6 Nov 94 8:49:37 GMT';
	 $date_parsed = APR::Date::parse_rfc($date_string);

Description
       "APR::Socket" provides the Perl interface to APR date manipulating functions.

API

       "APR::Date" provides the following functions and/or methods:

   "parse_http"
       Parse HTTP date strings

	 $date_parsed = parse_http($date_string);

       arg1: $date_string ( string )
	   The date string can be in one of the following formats:

	     Sun, 06 Nov 1994 08:49:37 GMT  ; RFC 822, updated by RFC 1123
	     Sunday, 06-Nov-94 08:49:37 GMT ; RFC 850, obsoleted by RFC 1036
	     Sun Nov  6 08:49:37 1994	    ; ANSI C's asctime() format

	   refer to RFC2616 for the details (GMT is assumed, regardless of the used timezone).

       ret: $date_parsed ( number )
	   the number of microseconds since 1 Jan 1970 GMT, or 0 if out of range or if the date is invalid.

       since: 2.0.00

       Remember to divide the return value by 1_000_000 if you need it in seconds.

   "parse_rfc"
       Parse a string resembling an RFC 822 date.  It's meant to be lenient in its parsing of dates.  Hence, this will parse a wider range of
       dates than "parse_http()".

	 $date_parsed = parse_rfc($date_string);

       arg1: $date_string ( string )
	   The date string can be in one of the following formats:

	     Sun, 06 Nov 1994 08:49:37 GMT  ; RFC 822, updated by RFC 1123
	     Sunday, 06-Nov-94 08:49:37 GMT ; RFC 850, obsoleted by RFC 1036
	     Sun Nov  6 08:49:37 1994	    ; ANSI C's asctime() format
	     Sun, 6 Nov 1994 08:49:37 GMT   ; RFC 822, updated by RFC 1123
	     Sun, 06 Nov 94 08:49:37 GMT    ; RFC 822
	     Sun, 6 Nov 94 08:49:37 GMT     ; RFC 822
	     Sun, 06 Nov 94 08:49 GMT	    ; Unknown [drtr@ast.cam.ac.uk]
	     Sun, 6 Nov 94 08:49 GMT	    ; Unknown [drtr@ast.cam.ac.uk]
	     Sun, 06 Nov 94 8:49:37 GMT     ; Unknown [Elm 70.85]
	     Sun, 6 Nov 94 8:49:37 GMT	    ; Unknown [Elm 70.85]

       ret: $date_parsed ( number )
	   the number of microseconds since 1 Jan 1970 GMT, or 0 if out of range or if the date is invalid.

       since: 2.0.00

       Remember to divide the return value by 1_000_000 if you need it in seconds.

See Also
       mod_perl 2.0 documentation.

Copyright
       mod_perl 2.0 and its core modules are copyrighted under The Apache Software License, Version 2.0.

Authors
       The mod_perl development team and numerous contributors.

perl v5.14.2							    2011-02-08		     libapache2-mod-perl2-2.0.7::docs::api::APR::Date(3pm)