Re: [WebDNA] Need to convert unix date?
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 104184
interpreted = N
texte = Works on my servers, must be a config issue!On Dec 16, 2009, at 3:58 PM, Dan Strong wrote:> What is your date format set to in your WebDNA admin? Mine is ="Month/Date/Year (American)"?>=20> -Dan Strong> http://www.DanStrong.com>=20> On 12/16/2009 1:55 PM, David Bastedo wrote:>> So when I put that code on my server, I get 3909 as the year. I have>> tried it on two different servers, so I am not sure what is up.>>=20>> ----->> [math]val=3D1252257406*1[/math] =3D [math date]{01/01/1970} + ={[format>> days_to_date %m/%d/%Y][format>> .6d][math]([val]/86400)[/math][/format][/format]}[/math]>> 1252257406=3D09/06/3909>>=20>> I have deconstructed the original time stamp to:>>=20>>=20>> [Math>> =show=3Df]subTotal=3D[Math]{09/14/2009}[/math]-[Math]{01/01/1970}[/math][/m=ath]>> total time + days + 1 day - 5 hours>> =3D[math]([subTotal]*86400)+{06:08:54}+86400-18000[/math]=3D>> [reaction_published]>>=20>> so technically, if I do this in the reverse, I should get what I need =. . .>>=20>> d.>>=20>>=20>>=20>>=20>>=20>>=20>> On Wed, Dec 16, 2009 at 4:01 PM, Marc Thompson =
> > wrote:>>=20>> Not sure what the "+1" is for from Dan's example besides adding an =extra>> day? However, I put the code on my server so you could see it =working.>> http://webapps.utah.edu/test/temp.tpl>>=20>> Seems to work fine on my server, which is -7DST.>>=20>> You would need to add some more formatting code to get it in the =form>> you show in your previous post.>> ie. The timestamp 1252976934 corresponds to 2009/09/14 06:08:54 pm =PDT.>>=20>> Marc>>=20>> David Bastedo wrote:>> > 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=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>> >> > >>> > > >> >>> =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=3Dtopics&category=3D288=>> >> > > >>> > > > >> > > >>>> > >>> > >>> > >>> > >>> > > -->> > > 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>>=20>> -->> ------------------------------------------->> Marc Thompson>> Software Engineer>> Office of Information Technology>> University of Utah>> 801.585.9264>> marc.thompson@utah.edu >> ------------------------------------------->>=20>>=20>>=20>>=20>> -->> 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=3Dtopics&category=3D288
Associated Messages, from the most recent to the oldest:
Works on my servers, must be a config issue!On Dec 16, 2009, at 3:58 PM, Dan Strong wrote:> What is your date format set to in your WebDNA admin? Mine is ="Month/Date/Year (American)"?>=20> -Dan Strong> http://www.DanStrong.com>=20> On 12/16/2009 1:55 PM, David Bastedo wrote:>> So when I put that code on my server, I get 3909 as the year. I have>> tried it on two different servers, so I am not sure what is up.>>=20>> ----->> [math]val=3D1252257406*1[/math] =3D [math date]{01/01/1970} + ={[format>> days_to_date %m/%d/%Y][format>> .6d][math]([val]/86400)[/math][/format][/format]}[/math]>> 1252257406=3D09/06/3909>>=20>> I have deconstructed the original time stamp to:>>=20>>=20>> [Math>> =show=3Df]subTotal=3D[math]{09/14/2009}[/math]-[math]{01/01/1970}[/math][/m=ath]>> total time + days + 1 day - 5 hours>> =3D[math]([subTotal]*86400)+{06:08:54}+86400-18000[/math]=3D>> [reaction_published]>>=20>> so technically, if I do this in the reverse, I should get what I need =. . .>>=20>> d.>>=20>>=20>>=20>>=20>>=20>>=20>> On Wed, Dec 16, 2009 at 4:01 PM, Marc Thompson => > wrote:>>=20>> Not sure what the "+1" is for from Dan's example besides adding an =extra>> day? However, I put the code on my server so you could see it =working.>> http://webapps.utah.edu/test/temp.tpl>>=20>> Seems to work fine on my server, which is -7DST.>>=20>> You would need to add some more formatting code to get it in the =form>> you show in your previous post.>> ie. The timestamp 1252976934 corresponds to 2009/09/14 06:08:54 pm =PDT.>>=20>> Marc>>=20>> David Bastedo wrote:>> > 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=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>> >> > >>> > > >> >>> =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=3Dtopics&category=3D288=>> >> > > >>> > > > >> > > >>>> > >>> > >>> > >>> > >>> > > -->> > > 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>>=20>> -->> ------------------------------------------->> Marc Thompson>> Software Engineer>> Office of Information Technology>> University of Utah>> 801.585.9264>> marc.thompson@utah.edu >> ------------------------------------------->>=20>>=20>>=20>>=20>> -->> 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=3Dtopics&category=3D288
Bob Minor
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:
[WebDNA] mod_WebDNA_apache2.2.so: mach-0, but wrong architecture (2010)
Re:Running 2 two WebCatalog.acgi's (1996)
Secure server question (1997)
Email password -- was Classified Ads 4 Sale (1998)
[DOS]/DOS query perhaps OT (2003)
EMailer - WebSTAR V - OSX - WebDNA (2003)
RE: creating writefile data from a nested search (1997)
'does not contain' operator needed ... (1997)
WCS Newbie question (1997)
French characters in variables (2001)
[WebDNA] Searching for multiple bits of data in one field or use (2016)
Problems getting parameters passed into email. (1997)
2.0 Info (1997)
Email (1998)
The Best Shopping Cart Solution I Have Come Upon (2003)
Dealer locator (1998)
Lookup question (2001)
problem (how to mark orders as 'opened') (1998)
Cart Question (1998)
Allow-Deny: Solved with [Getchars] (1998)