Re: [WebDNA] Need to convert unix date?

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 104171
interpreted = N
texte = --0016e64cca0c8aacae047adc341b Content-Type: text/plain; charset=ISO-8859-1 Unfortunately, I get: 09/16/3909 with the code below: I'm trying to work through this . . . d. On Wed, Dec 16, 2009 at 11:17 AM, Marc Thompson wrote: > Here you go: > > [math]val=1252976934*1[/math] = [math date]{01/01/1970} + {[format > days_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 > > wrote: > > > > Try this: > > > > [format days_to_date %m/%d/%Y][format > > .6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/format] > > > > > > > > On 12/15/2009 3:47 PM, David Bastedo wrote: > > > > Hi, I need to convert a date stored in unix format - seconds > > since Jan > > 01, 1970. Is there a formula or function that anybody might have? > > > > I am pulling in an xml file generated by an external api and > > that date > > comes in this format. > > > > thanks. > > > > d. > > > > > > -- > > David Bastedo > > Ten Plus One Communications Inc. > > http://www.10plus1.com > > T. 416.603.2223 > > M. 416.277.4499 > > > > --------------------------------------------------------- > > This message is sent to you because you are subscribed to > > the mailing list >. > > To unsubscribe, E-mail to: > > > > archives: http://mail.webdna.us/list/talk@webdna.us > > old archives: http://dev.webdna.us/TalkListArchive/ > > Bug Reporting: > > http://forum.webdna.us/eucabb.html?page=topics&category=288 > > > > > > > > > > > > -- > > David Bastedo > > Ten Plus One Communications Inc. > > http://www.10plus1.com > > T. 416.603.2223 > > M. 416.277.4499 > > -- > ------------------------------------------- > Marc Thompson > Software Engineer > Office of Information Technology > University of Utah > 801.585.9264 > marc.thompson@utah.edu > ------------------------------------------- > -- David Bastedo Ten Plus One Communications Inc. http://www.10plus1.com T. 416.603.2223 M. 416.277.4499 --0016e64cca0c8aacae047adc341b Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Unfortunately, I get: 09/16/3909=A0 =20 with the code below:

I'm trying to work through this . . .
=
d.


On Wed, Dec 16, 2009 at 11:17 AM, Marc T= hompson <mthompson@media.utah.edu> wrote:
Here you go:

[math]val=3D1252976934*1[/math] =3D [math date]{01/01/1970} + {[format
days_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 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 the mailing list <talk@webdna.us <mailto:talk@webdna.us>>.
> =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@webdna.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.thompson@utah.edu
-------------------------------------------



--
David BastedoTen Plus One Communications Inc.
http://www.10plus1.com
T. =A0416.603.2223
M. 416.2= 77.4499
--0016e64cca0c8aacae047adc341b-- Associated Messages, from the most recent to the oldest:

    
  1. Fwd: [WebDNA] Need to convert unix date? (William DeVaul 2011)
  2. Re: [WebDNA] Need to convert unix date? (Donovan Brooke 2009)
  3. Re: [WebDNA] Need to convert unix date? (Donovan Brooke 2009)
  4. Re: [WebDNA] Need to convert unix date? (Marc Thompson 2009)
  5. Re: [WebDNA] Need to convert unix date? (christophe.billiottet@webdna.us 2009)
  6. Re: [WebDNA] Need to convert unix date? (Govinda 2009)
  7. Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
  8. Re: [WebDNA] Need to convert unix date? ("Terry Wilson" 2009)
  9. Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
  10. Re: [WebDNA] Need to convert unix date? (Stuart Tremain 2009)
  11. Re: [WebDNA] Need to convert unix date? (Brian Fries 2009)
  12. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  13. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  14. Re: [WebDNA] Need to convert unix date? (Bob Minor 2009)
  15. Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
  16. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  17. Re: [WebDNA] Need to convert unix date? (Marc Thompson 2009)
  18. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  19. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  20. Re: [WebDNA] Need to convert unix date? (Marc Thompson 2009)
  21. Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
  22. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  23. Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
  24. [WebDNA] Need to convert unix date? (David Bastedo 2009)
--0016e64cca0c8aacae047adc341b Content-Type: text/plain; charset=ISO-8859-1 Unfortunately, I get: 09/16/3909 with the code below: I'm trying to work through this . . . d. On Wed, Dec 16, 2009 at 11:17 AM, Marc Thompson wrote: > Here you go: > > [math]val=1252976934*1[/math] = [math date]{01/01/1970} + {[format > days_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 > > wrote: > > > > Try this: > > > > [format days_to_date %m/%d/%Y][format > > .6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/format] > > > > > > > > On 12/15/2009 3:47 PM, David Bastedo wrote: > > > > Hi, I need to convert a date stored in unix format - seconds > > since Jan > > 01, 1970. Is there a formula or function that anybody might have? > > > > I am pulling in an xml file generated by an external api and > > that date > > comes in this format. > > > > thanks. > > > > d. > > > > > > -- > > David Bastedo > > Ten Plus One Communications Inc. > > http://www.10plus1.com > > T. 416.603.2223 > > M. 416.277.4499 > > > > --------------------------------------------------------- > > This message is sent to you because you are subscribed to > > the mailing list >. > > To unsubscribe, E-mail to: > > > > archives: http://mail.webdna.us/list/talk@webdna.us > > old archives: http://dev.webdna.us/TalkListArchive/ > > Bug Reporting: > > http://forum.webdna.us/eucabb.html?page=topics&category=288 > > > > > > > > > > > > -- > > David Bastedo > > Ten Plus One Communications Inc. > > http://www.10plus1.com > > T. 416.603.2223 > > M. 416.277.4499 > > -- > ------------------------------------------- > Marc Thompson > Software Engineer > Office of Information Technology > University of Utah > 801.585.9264 > marc.thompson@utah.edu > ------------------------------------------- > -- David Bastedo Ten Plus One Communications Inc. http://www.10plus1.com T. 416.603.2223 M. 416.277.4499 --0016e64cca0c8aacae047adc341b Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Unfortunately, I get: 09/16/3909=A0 =20 with the code below:

I'm trying to work through this . . .
=
d.


On Wed, Dec 16, 2009 at 11:17 AM, Marc T= hompson <mthompson@media.utah.edu> wrote:
Here you go:

[math]val=3D1252976934*1[/math] =3D [math date]{01/01/1970} + {[format
days_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 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 the mailing list <talk@webdna.us <mailto:talk@webdna.us>>.
> =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@webdna.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.thompson@utah.edu
-------------------------------------------



--
David BastedoTen Plus One Communications Inc.
http://www.10plus1.com
T. =A0416.603.2223
M. 416.2= 77.4499
--0016e64cca0c8aacae047adc341b-- David Bastedo

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

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...

Related Readings:

WebCat editing, SiteGuard & SiteEdit (1997) [WebDNA] Help me install (WebDNA 7 fastcgi install on Lion 10.7.3) (2012) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Forbidden CGI Error (1997) SpiderBotLock! (2003) ShowNext example for GeneralStore (1997) RAM variables (1997) can you take a look (2003) [WebDNA] Cheers (2008) Disappearing HTML/WebDNA (1998) WebCat2b12 Mac.acgi--[searchstring] bug (1997) Need some assistance. (1999) [WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010) Show items based on login Password (2003) Banner DNA (1997) too many nested [xxx] (1997) [showif] question (2000) Forms Search Questions (1997) [include] affect on filepaths for links? (1997) syntax question, not in online refernce (1997)