|
|
|
|
|||||||
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
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 | 8 | 04-24-2008 03:04 AM |
| Perl: Extracting date from file name and comparing with current date | MKNENI | Shell Programming and Scripting | 4 | 03-26-2008 12:01 PM |
| date issue-find prevoius date in a patricular format | bsandeep_80 | UNIX for Advanced & Expert Users | 3 | 11-15-2007 04:42 PM |
| Changing Creation Date to a Prespecified Date of a File In Unix | monkfan | UNIX for Dummies Questions & Answers | 4 | 11-28-2006 03:15 AM |
| Specify a previous date as start date in shell script | ritzwan0 | Shell Programming and Scripting | 2 | 09-25-2006 02:58 PM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
04-16-2007
|
|||
|
|||
|
Date aritematic
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 
|
| Forum Sponsor | ||
|
|
|
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.
|
|
04-16-2007
|
||||
|
||||
|
I recommend reading the FAQ's: Yesterdays Date/Date Arithmetic
|
||||
| Google UNIX.COM |
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
