Here you go:
[math]val=3D1252976934*1[/math] =3D [math date]{01/01/1970} + {[formatdays_to_date %m/%d/%Y][format.6d][math]([val]/86400)+1[/math][/format][/format]}[/math]
Marc
David Bastedo wrote:
> The timestamp *1252976934* corresponds to* 2009/09/14 06:08:54 pm PDT*=.
>
> this is the time stamp: *1252976934*
>
> [format days_to_date %m/%d/%Y][format
> .6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/format]
>
> gets me: 09/16/39
>
> d.
>
> On Tue, Dec 15, 2009 at 6:54 PM, Dan Strong <webdna@danstrong.com> <mailto:webdna@danstrong.com>> wrote:> =A0 =A0 the mailing list <t=alk@webdna.us <mailto:talk@webdna.=us>>.
>
> =A0 =A0 Try this:
>
> =A0 =A0 [format days_to_date %m/%d/%Y][format
> =A0 =A0 .6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/for=mat]
>
>
>
> =A0 =A0 On 12/15/2009 3:47 PM, David Bastedo wrote:
>
> =A0 =A0 =A0 =A0 Hi, I need to convert a date stored in unix format - s=econds
> =A0 =A0 =A0 =A0 since Jan
> =A0 =A0 =A0 =A0 01, 1970. Is there a formula or function that anybody =might have?
>
> =A0 =A0 =A0 =A0 I am pulling in an xml file generated by an external a=pi and
> =A0 =A0 =A0 =A0 that date
> =A0 =A0 =A0 =A0 comes in this format.
>
> =A0 =A0 =A0 =A0 thanks.
>
> =A0 =A0 =A0 =A0 d.
>
>
> =A0 =A0 =A0 =A0 --
> =A0 =A0 =A0 =A0 David Bastedo
> =A0 =A0 =A0 =A0 Ten Plus One Communications Inc.
> =A0 =A0 =A0 =A0 h=ttp://www.10plus1.com
> =A0 =A0 =A0 =A0 T. =A0416.603.2223
> =A0 =A0 =A0 =A0 M. 416.277.4499
>
> =A0 =A0 ---------------------------------------------------------
> =A0 =A0 This message is sent to you because you are subscribed to> =A0 =A0 To unsubscribe, E-mail to: <talk-leave@webdna.us> =A0 =A0 <mailto:talk-=leave@webdna.us>>> =A0 =A0 archives: http://mail.webdna.us/list/talk@webdn=a.us--
> =A0 =A0 old archives: http://dev.webdna.us/TalkListArchive/
> =A0 =A0 Bug Reporting:
> =A0 =A0 http://forum.webdna.us/eucabb.html?page==3Dtopics&category=3D288
> =A0 =A0 <http://forum.webdna.us/eucabb.html?=page=3Dtopics&category=3D288>
>
>
>
>
> --
> David Bastedo
> Ten Plus One Communications Inc.
> http://www.10plus=1.com
> T. =A0416.603.2223
> M. 416.277.4499
-------------------------------------------
Marc Thompson
Software Engineer
Office of Information Technology
University of Utah
801.585.9264
marc.thom=pson@utah.edu
-------------------------------------------
Here you go:
[math]val=3D1252976934*1[/math] =3D [math date]{01/01/1970} + {[formatdays_to_date %m/%d/%Y][format.6d][math]([val]/86400)+1[/math][/format][/format]}[/math]
Marc
David Bastedo wrote:
> The timestamp *1252976934* corresponds to* 2009/09/14 06:08:54 pm PDT*=.
>
> this is the time stamp: *1252976934*
>
> [format days_to_date %m/%d/%Y][format
> .6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/format]
>
> gets me: 09/16/39
>
> d.
>
> On Tue, Dec 15, 2009 at 6:54 PM, Dan Strong <webdna@danstrong.com> <mailto:webdna@danstrong.com>> wrote:> =A0 =A0 the mailing list <t=alk@webdna.us <mailto:talk@webdna.=us>>.
>
> =A0 =A0 Try this:
>
> =A0 =A0 [format days_to_date %m/%d/%Y][format
> =A0 =A0 .6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/for=mat]
>
>
>
> =A0 =A0 On 12/15/2009 3:47 PM, David Bastedo wrote:
>
> =A0 =A0 =A0 =A0 Hi, I need to convert a date stored in unix format - s=econds
> =A0 =A0 =A0 =A0 since Jan
> =A0 =A0 =A0 =A0 01, 1970. Is there a formula or function that anybody =might have?
>
> =A0 =A0 =A0 =A0 I am pulling in an xml file generated by an external a=pi and
> =A0 =A0 =A0 =A0 that date
> =A0 =A0 =A0 =A0 comes in this format.
>
> =A0 =A0 =A0 =A0 thanks.
>
> =A0 =A0 =A0 =A0 d.
>
>
> =A0 =A0 =A0 =A0 --
> =A0 =A0 =A0 =A0 David Bastedo
> =A0 =A0 =A0 =A0 Ten Plus One Communications Inc.
> =A0 =A0 =A0 =A0 h=ttp://www.10plus1.com
> =A0 =A0 =A0 =A0 T. =A0416.603.2223
> =A0 =A0 =A0 =A0 M. 416.277.4499
>
> =A0 =A0 ---------------------------------------------------------
> =A0 =A0 This message is sent to you because you are subscribed to> =A0 =A0 To unsubscribe, E-mail to: <talk-leave@webdna.us> =A0 =A0 <mailto:talk-=leave@webdna.us>>> =A0 =A0 archives: http://mail.webdna.us/list/talk@webdn=a.us--
> =A0 =A0 old archives: http://dev.webdna.us/TalkListArchive/
> =A0 =A0 Bug Reporting:
> =A0 =A0 http://forum.webdna.us/eucabb.html?page==3Dtopics&category=3D288
> =A0 =A0 <http://forum.webdna.us/eucabb.html?=page=3Dtopics&category=3D288>
>
>
>
>
> --
> David Bastedo
> Ten Plus One Communications Inc.
> http://www.10plus=1.com
> T. =A0416.603.2223
> M. 416.277.4499
-------------------------------------------
Marc Thompson
Software Engineer
Office of Information Technology
University of Utah
801.585.9264
marc.thom=pson@utah.edu
-------------------------------------------
DOWNLOAD WEBDNA NOW!
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...