Re: [WebDNA] Need to convert unix date?
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 104193
interpreted = N
texte = From the help: "When set to 'Yes', [math date] will use the 'Date Display Format'."-Dan Stronghttp://www.DanStrong.comOn 12/16/2009 2:13 PM, David Bastedo wrote:> what does: Math to use Date Display Format? do in the config? it is set> to no?>> On Wed, Dec 16, 2009 at 5:08 PM, Bob Minor
> wrote:>> 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)"?> >> > -Dan Strong> > http://www.DanStrong.com> >> > 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.> >>> >> -----> >> [math]val=1252257406*1[/math] = [math date]{01/01/1970} + {[format> >> days_to_date %m/%d/%Y][format> >> .6d][math]([val]/86400)[/math][/format][/format]}[/math]> >> 1252257406=09/06/3909> >>> >> I have deconstructed the original time stamp to:> >>> >>> >> [Math> >>> show=f]subTotal=[Math]{09/14/2009}[/math]-[Math]{01/01/1970}[/math][/math]> >> total time + days + 1 day - 5 hours> >> =[math]([subTotal]*86400)+{06:08:54}+86400-18000[/math]=> >> [reaction_published]> >>> >> so technically, if I do this in the reverse, I should get what I> need . . .> >>> >> d.> >>> >>> >>> >>> >>> >>> >> On Wed, Dec 16, 2009 at 4:01 PM, Marc Thompson> > >> >> wrote:> >>> >> 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> >>> >> Seems to work fine on my server, which is -7DST.> >>> >> 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.> >>> >> Marc> >>> >> 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=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> >>> >> --> >> -------------------------------------------> >> 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> > ---------------------------------------------------------> > 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> >> ---------------------------------------------------------> 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
Associated Messages, from the most recent to the oldest:
From the help: "When set to 'Yes', [math date] will use the 'Date Display Format'."-Dan Stronghttp://www.DanStrong.comOn 12/16/2009 2:13 PM, David Bastedo wrote:> what does: Math to use Date Display Format? do in the config? it is set> to no?>> On Wed, Dec 16, 2009 at 5:08 PM, Bob Minor > wrote:>> 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)"?> >> > -Dan Strong> > http://www.DanStrong.com> >> > 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.> >>> >> -----> >> [math]val=1252257406*1[/math] = [math date]{01/01/1970} + {[format> >> days_to_date %m/%d/%Y][format> >> .6d][math]([val]/86400)[/math][/format][/format]}[/math]> >> 1252257406=09/06/3909> >>> >> I have deconstructed the original time stamp to:> >>> >>> >> [Math> >>> show=f]subTotal=[math]{09/14/2009}[/math]-[math]{01/01/1970}[/math][/math]> >> total time + days + 1 day - 5 hours> >> =[math]([subTotal]*86400)+{06:08:54}+86400-18000[/math]=> >> [reaction_published]> >>> >> so technically, if I do this in the reverse, I should get what I> need . . .> >>> >> d.> >>> >>> >>> >>> >>> >>> >> On Wed, Dec 16, 2009 at 4:01 PM, Marc Thompson> > >> >> wrote:> >>> >> 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> >>> >> Seems to work fine on my server, which is -7DST.> >>> >> 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.> >>> >> Marc> >>> >> 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=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> >>> >> --> >> -------------------------------------------> >> 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> > ---------------------------------------------------------> > 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> >> ---------------------------------------------------------> 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
Dan Strong
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:
What is WebDNA (1997)
WebCatalog 4.0.1 has been released! OSXS (2000)
[OT] I'm looking for a new job ... (2004)
form data submission gets truncated (1997)
What abobut variables named max ??? (2000)
Searching on 3 different fields *CORRECTION* (2003)
Using Applescript to process WebCatalog functions (1998)
Accepting credit cards (1997)
WebCat2 several catalogs? (1997)
WebCat2 several catalogs? (1997)
Quitting WebMerchant ? (1997)
Requiring that certain fields be completed (1997)
too many nested ... problem (1997)
WC2f3 (1997)
[format xs] freeze (1997)
Roundup function? (1997)
Sku numbers (1997)
writing db to disk (1997)
Setting a text Var inside an orderfile (2002)
Attention SM: Trigger Bug? (2000)