How to conver YYYYMMDD to MJD format?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to conver YYYYMMDD to MJD format?
# 1  
Old 09-22-2016
How to conver YYYYMMDD to MJD format?

I would like to convert YYYYMMDD to MJD format
for eg 20041223 converted to 53362 in MJD format i got logic from javascript to covert it to MJD which is long enough
Code:
function YMDtoMJD (year, month, day)
{    

    var year;
    var monthi
    var day;
    var yr  = Math.floor (year); 
    var mn  = Math.floor (month);
    var day = Math.floor (day);          
    var hr  = 0.0;                    // Hours are not valid
    var L;
    var julian;    
    var mjd;
        
        
    // In leap years, -1 for Jan, Feb, else 0
    L = Math.ceil ((mn - 14) / 12);
             
    var p1 = day - 32075 + Math.floor (1461 * (yr + 4800 + L) / 4);
    
    var p2 = Math.floor (367 * (mn - 2 - L * 12) / 12);
    var p3 = 3 * Math.floor (Math.floor ((yr + 4900 + L) / 100) / 4);
    
    julian = p1 + p2 - p3;        
    julian = julian + (hr / 24.0) - 0.5;
  
    mjd = julian - 2400000.5;
    
    
    return (mjd);

}

Can anyone help me what is the easiest way to achieve in shell script?
# 2  
Old 09-22-2016
Hi,
Under linux (with shell bash), maybe:
Code:
$ echo $(($(date "+%s" -d 20041223)/86400+40588))
53362

Regards.
These 2 Users Gave Thanks to disedorgue For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date format to be changed from DDMMYYYY to YYYYMMDD

My requirement is:- there will be files at a location each day with the date format DDMMYYYY. Novawise_Activity_Call_Notes_04022013.txt Novawise_Activity_Inbound_04022013.txt Novawise_Activity_Inbound_05022013.txt Novawise_Activity_Call_Notes_05022013.txt... (8 Replies)
Discussion started by: djrulz123
8 Replies

2. Shell Programming and Scripting

Validating date in yyyymmdd format using PERL

Hi all, i had a code where in user will enter a date in yyyymmdd format.. i didnt use any validation for the date and now the problem is if a user enters date instead of month after year it is proceeding with the code.. like if the date is 20120426 and if the user enters 20122604 it... (4 Replies)
Discussion started by: smarty86
4 Replies

3. Solaris

Date after 5 dates in YYYYMMDD format

Hi Experts, How to get date 5 days after current date in YYYYMMDD format? How do we compare date in YYYYMMDD format? Thanks (1 Reply)
Discussion started by: needyourhelp10
1 Replies

4. Shell Programming and Scripting

Change the date format from mmddyyyy to yyyymmdd

How do I change the date format from mmddyyyy to yyyymmdd in PERL. Can any one help me please. (3 Replies)
Discussion started by: thankful123
3 Replies

5. Shell Programming and Scripting

convert date format YYYYMMDD to MM/DD/YYYY

In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY. Thanks. (8 Replies)
Discussion started by: nasirgondal
8 Replies

6. UNIX for Dummies Questions & Answers

Format date from MM/DD/YYYY to YYYYMMDD

I have a file with some date columns in MM/DD/YYYY format: SMPBR|DUP-DO NOT USE|NEW YORK||16105|BA5270715|6/6/2007 |MWERNER|109||||JOHN||SMITH|MD|72211118||||||74559|21 WILMINGTON RD||D|11/6/2003|SL# MD CONTACT-LIZ RICHARDS|||0|Y|N||1411458| And I want to convert the date format to: ... (5 Replies)
Discussion started by: ChicagoBlues
5 Replies

7. HP-UX

Conver Excel file to another format ( text)

I can convert a excel file to another format , for example text type ( TXT) whit anoter caracter from delimiter a rows ??? I can change the default delimiter " | " ( or space ) of cell to another caracter ( for example @@ or ## ) without change the other space ??? (6 Replies)
Discussion started by: ZINGARO
6 Replies

8. Shell Programming and Scripting

get yesterday in yyyymmdd format

how can i get yesterday in yyyymmdd format? :confused: (13 Replies)
Discussion started by: aaron_fong
13 Replies

9. HP-UX

How can i get the yesterday's date in YYYYMMDD format

How can i get the yesterday's date in YYYYMMDD format??? (4 Replies)
Discussion started by: prasadsr
4 Replies

10. UNIX for Dummies Questions & Answers

get yesterday date in yyyymmdd format

I would like to know how I could get a yesterday date in yyyymmdd e.g. today is 20011109, and I would like to get 20011108. Thank you!:confused: (2 Replies)
Discussion started by: hk_newbie
2 Replies
Login or Register to Ask a Question