Date aritematic

spring_buck · #1 (**permalink**) 04-16-2007

Hi,

Is there a way to write a shell script that does the following.

Calculate the difference between two dates in format
YYYY.MM.DD HH:MI:SS,sss.
The output must be in Milliseconds.

Date1 = 2007.04.16 10:54:19,428
Date2 = 2007.04.16 10:54:20,815

Date2 - Date1 = X milliseconds.

best regards,
Spring_buck

Shell_Life · #2 (**permalink**) 04-16-2007

Spring_buck,
A true date calculation can be very involved as you have to consider leap years.
What I recommend you to do is the following:
1) Define a temp table with two datetime fields.
2) Load all your datetime fields into the table.
3) Run the following select:
SELECT datetime_from, datetime_to, datetime_to - datetime_from
FROM your_table
This solution will prove to be much quicker to implement.

Perderabo · #3 (**permalink**) 04-16-2007

I recommend reading the FAQ's: Yesterdays Date/Date Arithmetic

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Compare date from db2 table to yesterday's Unix system date	sasaliasim	Shell Programming and Scripting	9	12-01-2008 11:37 PM
Perl: Extracting date from file name and comparing with current date	MKNENI	Shell Programming and Scripting	4	03-26-2008 04:01 PM
date issue-find prevoius date in a patricular format	bsandeep_80	UNIX for Advanced & Expert Users	3	11-15-2007 08:42 PM
Changing Creation Date to a Prespecified Date of a File In Unix	monkfan	UNIX for Dummies Questions & Answers	4	11-28-2006 07:15 AM
Specify a previous date as start date in shell script	ritzwan0	Shell Programming and Scripting	2	09-25-2006 05:58 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: