Calculating using date

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grouping and Calculating

Hi All, I want to read the input file and store the output in the Output file. I pasted the sample Input and Output file below. Help me with this. Input file ================================= ITEM1 AAAAA 1 ITEM1 BBBBB 1 ITEM1 CCCCC 1 ITEM2 AAAAA 5 ITEM2 CCCCC 4...

2. Shell Programming and Scripting

Calculating mean for samples 1-3 4-6 etc.

Hi. I have a LOOONG list of samples but I am not sure how to write the loop/script to calculate the mean... I normally use awk... ...................MEAN Sample1 25.82 40.61333 Sample1 47.6 Sample1 48.42 Sample2 54.03 54.12 Sample2 53.98 Sample2 54.35 etc..... I would like to...

3. Shell Programming and Scripting

Calculating the epoch time from standard time using awk and calculating the duration

Hi All, I have the following time stamp data in 2 columns Date TimeStamp(also with milliseconds) 05/23/2012 08:30:11.250 05/23/2012 08:30:15.500 05/23/2012 08:31.15.500 . . etc From this data I need the following output. 0.00( row1-row1 in seconds) 04.25( row2-row1 in...

4. Shell Programming and Scripting

Calculating expiry date using date,sed,grep

Hi, I would greatly appreciate it if someone can help me with my problem. I have a crawler which collects spam URLs everyday & this data needs to be published in a blacklist. Here's the catch: The "Time To Live" (TTL) for each URL is 3 months (or whatever for that matter). If i see the...

5. Shell Programming and Scripting

Calculating 7 days ago date for the given Argument

Hi I have shell script and I am facing the below issue to integrate the date calculation to the the script. If I give the $1 as the date(20110701) then I need to get the 7 days ago date for the same format.(20110624). At first I thought its a simple one to handle and I did a search in the...

6. UNIX and Linux Applications

sqlite: calculating with dates - compare current date minus 6 months with stored record

Hi I have a table with name, date in format DD.MM.YYYY. I need to something like this (I try to explain in pseudo code) if SYSDATE (current date) minus 6 months > $expiry date print OK else print NOK with $name and $expiry date I know this is possible with Oracle. How to do this...

7. UNIX for Dummies Questions & Answers

Calculating average

Hi, i have 12 float variables in a bash file and i want to calculate the average of them. Can any body help?

8. UNIX and Linux Applications

Calculating age from date of birth

MySQL... Given a column containing people's dates of birth, what's the best way to create a computed column giving their age in years...I can't find a suitable date/time function that'll do the job! :(

9. Shell Programming and Scripting

calculating in MB

hi all, have got a ksh script which tries to monitor memory usage of app servers. i do a ps -0 rss -p <PID> to get the memory size in KB but when i divide by 1024 to convert to MB i dont know how to round it up ?? thanks in advance.

10. Shell Programming and Scripting

calculating a number

Hello all :) I need some help; I'm running the sp_spaceused command on various tables and saving the output to a file. So, I have an input file that has 3 rows - each row has 7 columns. I would like to 1) sort the file on the 4th column, 2) take the 4th column in the first row and add 25% to...

LEARN ABOUT PHP

datetime.settimestamp

DATETIME.SETTIMESTAMP(3)						 1						  DATETIME.SETTIMESTAMP(3)

DateTime::setTimestamp - Sets the date and time based on an Unix timestamp

       Object oriented style

SYNOPSIS

       public DateTime DateTime::setTimestamp (int  $unixtimestamp)

DESCRIPTION

       Procedural style
       DateTime date_timestamp_set (DateTime  $object, int  $unixtimestamp)

	Sets the date and time based on an Unix timestamp.

PARAMETERS

	      o $object
		-Procedural style only: A DateTime object returned by date_create(3). The function modifies this object.

	      o $unixtimestamp
		- Unix timestamp representing the date.

RETURN VALUES

	Returns the DateTime object for method chaining or FALSE on failure.

EXAMPLES

       Example #1

	      DateTime.setTimestamp(3) example

	      Object oriented style

	      <?php
	      $date = new DateTime();
	      echo $date->format('U = Y-m-d H:i:s') . "
";

	      $date->setTimestamp(1171502725);
	      echo $date->format('U = Y-m-d H:i:s') . "
";
	      ?>

	      Procedural style

	      <?php
	      $date = date_create();
	      echo date_format($date, 'U = Y-m-d H:i:s') . "
";

	      date_timestamp_set($date, 1171502725);
	      echo date_format($date, 'U = Y-m-d H:i:s') . "
";
	      ?>

	      The above examples will output something similar to:

	      1272508903 = 2010-04-28 22:41:43
	      1171502725 = 2007-02-14 20:25:25

NOTES

	Using the Unix timestamp format to construct a new DateTime object is an alternative when using PHP 5.2, as shown in the example below.

       Example #2

	      DateTime.setTimestamp(3) alternative in PHP 5.2

	      <?php
	      $ts = 1171502725;
	      $date = new DateTime("@$ts");
	      echo $date->format('U = Y-m-d H:i:s') . "
";
	      ?>

	      The above example will output something similar to:

	      1171502725 = 2007-02-14 20:25:25

SEE ALSO 
DateTime.getTimestamp(3).
PHP Documentation Group 												  DATETIME.SETTIMESTAMP(3)

Shell Programming and Scripting