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:

quitting (1997) [ConvertChars] problem (1997) FYI-WebCat Mac or NT (1997) Erotic Sites (1997) Suddenly can't see files... (2000) How To question on setting up downloads (1997) convertWords... NEW (2001) WebCatalog2 Feature Feedback (1996) Grepping to remove text & code (2004) WebMerchant 3.0 for Mac shipping now (1998) Problems getting parameters passed into email. (1997) can WC render sites out? (1997) serial number dishing (1997) [WebDNA] Dead line Time Math (2017) Pre-flight public flag (1997) Email problem.. (2004) Date stamp and purging (1998) 2nd WebCatalog2 Feature Request (1996) Subtotal help (1997) RePost: NAT and the CART (1999)