Re: [WebDNA] Need to convert unix date?

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 104162
interpreted = N
texte = --0016e649c24e1e534e047acd7930 Content-Type: text/plain; charset=ISO-8859-1 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 --0016e649c24e1e534e047acd7930 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable The timestamp 1252976934 corresponds to 2009/09/14 06:08:54 pm PD= T.

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 P= M, Dan Strong <webdna@danstrong.com> wrote:
Try this:

[format days_to_date %m/%d/%Y][format .6d][math]([your_UNIX_timestamp]/8640= 0)+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. =A0416.603.2223
M. 416.277.4499
---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <ta= lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
old archives: http://dev.webdna.us/TalkListArchive/
Bug Reporting: http://forum.webdna.us/eucabb.html?pa= ge=3Dtopics&category=3D288



--
David Bastedo
Ten Pl= us One Communications Inc.
http://www= .10plus1.com
T. =A0416.603.2223
M. 416.277.4499
--0016e649c24e1e534e047acd7930-- 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)
--0016e649c24e1e534e047acd7930 Content-Type: text/plain; charset=ISO-8859-1 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 --0016e649c24e1e534e047acd7930 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable The timestamp 1252976934 corresponds to 2009/09/14 06:08:54 pm PD= T.

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 P= M, Dan Strong <webdna@danstrong.com> wrote:
Try this:

[format days_to_date %m/%d/%Y][format .6d][math]([your_UNIX_timestamp]/8640= 0)+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. =A0416.603.2223
M. 416.277.4499
---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <ta= lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
old archives: http://dev.webdna.us/TalkListArchive/
Bug Reporting: http://forum.webdna.us/eucabb.html?pa= ge=3Dtopics&category=3D288



--
David Bastedo
Ten Pl= us One Communications Inc.
http://www= .10plus1.com
T. =A0416.603.2223
M. 416.277.4499
--0016e649c24e1e534e047acd7930-- 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:

Redirect to anchor (2001) using showpage and showcart commands (1996) Page Breaks (1999) canEmail? (1998) Frames and WebCat (1997) IE Cache Problems... (1999) [WebDNA] Webserver does not respond occasionally (2018) WebMerchant and Mac Auth Hub Help Please (1999) Adding up line items. (2000) Upgrade Problem.... (1998) Syncing WebDNA w/ Palm (2005) Spaces inside [AppendFile] (1998) BUG in [showif] using ^ (contains) (1997) Summing fields (1997) Can you identify the [body]? (1999) server side includes & webcatalog (2000) HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) Re:no [search] with NT (1997) creating files dynamically (2002) WC1.6 to WC2 date formatting (1997)