Larry, I did find that the Unix Time Stamp is from January 1, 1970 in one reference. I'm just going to write a routine to pull the Month Day and Year out and create a CF date. Paul
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 11:13 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Hi Paul, There is something out there and I have used it, but it escaping me right now. I thought it used the word equinox or 01-01-2900 or time in the instructions/help files. Try a few Google searches and see what comes back. I am pretty sure about the starting date. Larry Paul Morton wrote: Larry, I suspected that was the "time=103...." , but I wasn't sure of the start date. Guess I could calculate it. I was going to pull the YEAR, MONTH, and DAY_OF_MONTH out and create a date in CF. Just thought there may be a function or something available. Paul -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 10:40 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Hi Paul, I would check to see if this is a converted date showing the number of seconds since 01-01-1900. That was a format used by some systems to hold the date in a numerical format for easier and a more universal storage format. I used to do this on *nix systems all the time. I will look around but I do not have the reverse readily available. Larry Paul Morton wrote: Hi all. I have a small problem for which I'm hoping there is a simple solution. I am pulling a date from an Informix database using an undocumented Web Service and I am getting a date that looks like: [time=1031295600000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone =sun.util.calendar.ZoneInfo[id="America/Los_Angeles",offset=-28800000,dstSav ings=3600000,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZ one[id=America/Los_Angeles,offset=-28800000,dstSavings=3600000,useDaylight=t rue,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTi me=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,end Time=7200000,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1 ,YEAR=2002,MONTH=8,WEEK_OF_YEAR=36,WEEK_OF_MONTH=1,DAY_OF_MONTH=6,DAY_OF_YEA R=249,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINU TE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=-28800000,DST_OFFSET=3600000] I need to get this into a CFML date format and I was about to start developing a parsing routine, and the thought occurred to me that someone might recognize this data format and have a ready made solution to parsing the date from this. Anybody have a quick solution, or should I just hard code a parser? Paul ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
