Hi Yogesh, Just had a quick look on the details you provided. Here is a solution, assuming NOLEAP calendar with a constant 365 days length for every year (please see the files in attached tar/gzipped file, date_decimal.tar.gz). Suppose the accurate year length is not 365 days. Then there are two possibilities (excluding the 360_DAY calendar) : 1. every year does have equal length: either 365.25 (JULIAN) or 365.2425 (GREGORIAN) days 2. normal years have a length of 365 days and leap years have a length of 366 days. If you precisely know which category your data belongs to, then modify date_decimal.jnl file (attached) according to that. Hope this helps, Regards, Jaison On Tue, 7 Aug 2007, Yogesh Tiwari wrote: > Hi Jaison, > > > > Hi Yogesh, > > To have a better answer to your question, please give the > > following basic details : > > > > 1. In 2006.121918, what does the ".121918" stands for? does it mean > > month=12, day=19, hours=18? > > > > or is it a fraction found by deviding month, day, hour, minute and > > second with the year length and adding together? > > > 2006.121918 stands for year plus fraction of the year. Fraction as well is > year and calculated as you said above. Each year has 48 weekly steps. > > 2. What is the calendar type? Julian, Gregorian, Noleap ....? > > > Its observation given in UTC and year is divided in 48 weeks then its > Julian I guess. > > 3. What all other variables you have in the ascii file? Please provide > the first few datalines. > > Basically its atmospheric CO2 observed data , and given like: > > > Time CO2(ppm) > > 1993.333333 361.7010 > > 1993.354167 361.0350 > > 1993.375000 360.2820 > > 1993.395833 359.5100 > > Thanks, > > > Regards, > > Yogesh > > > > On Tue, 7 Aug 2007, Yogesh Tiwari wrote: > > > Hello Ferret Users, > > > > I have an ASCII file in which one column represents decimal date, > something > > like 2006.121918 > > > > I want to convert this decimal date in equivalent date in the format YYYY > > mm dd hr min sec > > and write separate six columns. > > > > Is it possible in ferret ? > > > > Thanks, > > > > Cheers, > > Yogesh > > > > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > > > > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
Attachment:
decimal_date.tar.gz
Description: GNU Zip compressed data