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:

Emailed problem (2000) Signal Raised Error (Part II) (1997) Intranet Edition (2004) notification solutions (1997) When do we get to request new features? (1999) Nav4 not specifying cart (1997) WebCatalog can't find database (1997) PIXO (1997) Emailer again (1997) Multiple catalog databases and showcart (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) [SHOWIF] (1997) [math] storage of variables (1997) CommitDatabase vs. CloseDatabase (2001) Storefornts (1997) Search on encrypted field (2000) Re:WebMerchant 3.0 for Mac shipping now (1998) WebCat2 several catalogs? (1997) Searching multiple fields from one form field (1997) Error Lob.db records error message not name (1997)