Re: [WebDNA] Need to convert unix date?

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 104169
interpreted = N
texte = --0016e64756b4ab4966047adbcec8 Content-Type: text/plain; charset=ISO-8859-1 Thanks! Dan, I agree, I was thinking that somebody would have code and that I too, didn't want to devote a bunch of time to a seemingly simple thing. cheers. 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 --0016e64756b4ab4966047adbcec8 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks!

Dan, I agree, I was thinking that somebody would have code = and that I too, didn't want to devote a bunch of time to a seemingly si= mple thing.

cheers.

d.

On W= ed, Dec 16, 2009 at 11:17 AM, Marc Thompson <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 <t= alk@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@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
-------------------------------------------



--
David BastedoTen Plus One Communications Inc.
htt= p://www.10plus1.com
T. =A0416.603.2223
M. 416.277.4499
--0016e64756b4ab4966047adbcec8-- 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)
--0016e64756b4ab4966047adbcec8 Content-Type: text/plain; charset=ISO-8859-1 Thanks! Dan, I agree, I was thinking that somebody would have code and that I too, didn't want to devote a bunch of time to a seemingly simple thing. cheers. 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 --0016e64756b4ab4966047adbcec8 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks!

Dan, I agree, I was thinking that somebody would have code = and that I too, didn't want to devote a bunch of time to a seemingly si= mple thing.

cheers.

d.

On W= ed, Dec 16, 2009 at 11:17 AM, Marc Thompson <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 <t= alk@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@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
-------------------------------------------



--
David BastedoTen Plus One Communications Inc.
htt= p://www.10plus1.com
T. =A0416.603.2223
M. 416.277.4499
--0016e64756b4ab4966047adbcec8-- 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:

CSS (2001) [SHOWIF]s and empty arguments (1997) tcpconnect/tcpsend problem ... (2004) Append..... doesn't (2000) [WebDNA] OS and version (2019) Line items in table cells (1997) Speaking of... (1999) RE: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (2020) Summary search -- speed (1997) form data submission gets truncated (1997) Help! WebCat2 bug (1997) Webcatalog server support (1997) WebCommerce: Folder organization ? (1997) Emailer kaput? (2000) Re:What file? (1997) PIXO support (1997) Error 11 (1996) WebCat2 Append problem (B14Macacgi) (1997) [lookup] speed sales pitch (2003) Use of & in text areas.... (1998)