Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Find week of the year for given date using date command inside awk
Top Forums Shell Programming and Scripting Find week of the year for given date using date command inside awk Post 302902327 by clx on Tuesday 20th of May 2014 03:43:53 AM
Old 05-20-2014
Try
Code:
awk -v woy="$(date -d "$rt_date" +%-V)" -F"," 
'BEGIN { #some variable assignment}

{ #some calculation and put values in array}

END {
   year=#getting it from array and assume this will be 2014
   month=#getting it from array and this will be 05
   date=# getting it from array and this will be 20

   rt_date=year"-"month"-"woy (this will be 2014-05-20)

This User Gave Thanks to clx For This Post:
vijaidhas
 

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to find Day of the Week from the given date (Perl)?

How to find the Day of the Week of the given Date using perl? If I have a date in YYY--MM-DD format, how to find the DOW? Based on that, I need to find the following sunday. Pls help. (5 Replies)
Discussion started by: deepakwins
5 Replies

2. Shell Programming and Scripting

how to obtain date and day of the week from `date` command

Hi, does anybody know how to format `date` command correctly to return the day of the week? Thanks -A I work in ksh.... (1 Reply)
Discussion started by: aoussenko
1 Replies

3. Shell Programming and Scripting

Date One Week Ago From Given Date, Not From Current Date

Hi all, I've used various scripts in the past to work out the date last week from the current date, however I now have a need to work out the date 1 week from a given date. So for example, if I have a date of the 23rd July 2010, I would like a script that can work out that one week back was... (4 Replies)
Discussion started by: Donkey25
4 Replies

4. Shell Programming and Scripting

Extract week start,end date from given date in PERL

Hi All, what i want to do in perl is i should give the date at run time .Suppose date given is 23/12/2011(mm/dd/yyyy) the perl script shold find week start date, week end date, previous week start date,end date,next week start date, end date. In this case week start date will be-:12/19/2011... (2 Replies)
Discussion started by: parthmittal2007
2 Replies

5. Shell Programming and Scripting

Help in using date command inside awk

Hi All, bash-3.2$ autorep -J BOX_NAME% -l0 | grep BOX_NAME| awk -f awkScript.awk sh: -c: line 0: unexpected EOF while looking for matching `"' sh: -c: line 1: syntax error: unexpected end of file BOX_NAME SU 06/21/2013 03:44:03 06/21/2013 07:46:37 0 #My awkfile { ... (3 Replies)
Discussion started by: ddspark
3 Replies

6. Shell Programming and Scripting

How to find all files other than first two dates & last date per month and year?

how to find all files other than first two dates & last date per month and year Hi All, lets say there are following files in directory -rwxr-xr-x 1 user userg 1596 Mar 19 2012 a.txt -rwxr-xr-x 1 user userg 1596 Mar 19 2012 b.txt -rwxr-xr-x 1 user userg ... (6 Replies)
Discussion started by: Makarand Dodmis
6 Replies

7. UNIX for Beginners Questions & Answers

How bash treats literal date value and retrieve year, month and date?

Hi, I am trying to add few (say 3 days) to sysdate using - date -d '+ 3 days' +%y%m%d and it works as expected. But how to add few (say 3 days) to a literal date value and how bash treats a literal value as a date. Can we say just like in ORACLE TO_DATE that my given literal date value... (2 Replies)
Discussion started by: pointers1234
2 Replies

LEARN ABOUT PHP

getdate

GETDATE(3)								 1								GETDATE(3)

getdate - Get date/time information

SYNOPSIS

       array getdate ([int  $timestamp = time()])

DESCRIPTION

	Returns an associative array containing the date information of the $timestamp, or the current local time if no $timestamp is given.

PARAMETERS

	      o $timestamp
		-  The	optional  $timestamp parameter is an integer Unix timestamp that defaults to the current local time if a $timestamp is not
		given. In other words, it defaults to the value of time(3).

RETURN VALUES

	Returns an associative array of information related to the $timestamp. Elements from the returned associative array are as follows:

       Key elements of the returned associative array

       +----------+--------------------------------------+---+
       |   Key	  |					 |   |
       |	  |					 |   |
       |	  |		Description		 |   |
       |	  |					 |   |
       |	  |	  Example returned values	 |   |
       |	  |					 |   |
       +----------+--------------------------------------+---+
       |	  |					 |   |
       |"seconds" |					 |   |
       |	  |					 |   |
       |	  |  Numeric representation of seconds	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  0 to 59		 |   |
       |	  |					 |   |
       |	  |					 |   |
       |"minutes" |					 |   |
       |	  |					 |   |
       |	  |  Numeric representation of minutes	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  0 to 59		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "hours"  |					 |   |
       |	  |					 |   |
       |	  |   Numeric representation of hours	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  0 to 23		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "mday"   |					 |   |
       |	  |					 |   |
       |	  | Numeric representation of the day of |   |
       |	  | the month				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  1 to 31		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "wday"   |					 |   |
       |	  |					 |   |
       |	  | Numeric representation of the day of |   |
       |	  | the week				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  | 0 (for Sunday) through 6 (for Satur- |   |
       |	  | day)				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |  "mon"   |					 |   |
       |	  |					 |   |
       |	  |  Numeric representation of a month	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		1 through 12		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "year"   |					 |   |
       |	  |					 |   |
       |	  | A  full  numeric representation of a |   |
       |	  | year, 4 digits			 |   |
       |	  |					 |   |
       |	  |	   Examples: 1999 or 2003	 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "yday"   |					 |   |
       |	  |					 |   |
       |	  | Numeric representation of the day of |   |
       |	  | the year				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |	       0 through 365		 |   |
       |	  |					 |   |
       |	  |					 |   |
       |"weekday" |					 |   |
       |	  |					 |   |
       |	  | A full textual representation of the |   |
       |	  | day of the week			 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |	  Sunday through Saturday	 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "month"  |					 |   |
       |	  |					 |   |
       |	  | A full textual representation  of  a |   |
       |	  | month, such as January or March	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |	  January through December	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |    0	  |					 |   |
       |	  |					 |   |
       |	  |  Seconds since the Unix Epoch, simi- |   |
       |	  | lar  to  the  values   returned   by |   |
       |	  | time(3) and used by date(3).	 |   |
       |	  |					 |   |
       |	  |  System	Dependent,     typically |   |
       |	  | -2147483648 through 2147483647.	 |   |
       |	  |					 |   |
       +----------+--------------------------------------+---+
EXAMPLES

       Example #1

	      getdate(3) example

	      <?php
	      $today = getdate();
	      print_r($today);
	      ?>

	      The above example will output something similar to:

	      Array
	      (
		  [seconds] => 40
		  [minutes] => 58
		  [hours]   => 21
		  [mday]    => 17
		  [wday]    => 2
		  [mon]     => 6
		  [year]    => 2003
		  [yday]    => 167
		  [weekday] => Tuesday
		  [month]   => June
		  [0]	    => 1055901520
	      )

SEE ALSO

       date(3), idate(3), localtime(3), time(3), setlocale(3).

PHP Documentation Group 														GETDATE(3)
All times are GMT -4. The time now is 12:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy