Larry
Paul Morton wrote:
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 ofthe start date. Guess I could calculate it. I was going to pull the YEAR, MONTH, and DAY_OF_MONTH out andcreate 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,dstSavings=3600000,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZone[id=America/Los_Angeles,offset=-28800000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=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_YEAR=249,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=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 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 -------------------------------------------------------------