Re: [WebDNA] Need to convert unix date?

This WebDNA talk-list message is from

2009

It keeps the original formatting. numero = 104196
interpreted = N
texte = This is a cryptographically signed message in MIME format.--------------ms070007070607060404040807Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: 7bitTry looking here:http://docs.webdna.us/MajorGroups.htmlCheck the "Dates & Times" section...MarcDavid 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-- -------------------------------------------Marc ThompsonSoftware EngineerOffice of Information TechnologyUniversity of Utah801.585.9264marc.thompson@utah.edu---------------------------------------------------------ms070007070607060404040807Content-Type: application/x-pkcs7-signature; name="smime.p7s"Content-Transfer-Encoding: base64Content-Disposition: attachment; filename="smime.p7s"Content-Description: S/MIME Cryptographic SignatureMIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIIyTCCAr8wggIooAMCAQICEBsJjtdroK6bD6QFOjpu3bIwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA5MDIyMzE5MzkyNVoXDTEwMDIyMzE5MzkyNVowgYoxETAPBgNVBAQTCFRob21wc29uMQ0wCwYDVQQqEwRNYXJjMRYwFAYDVQQDEw1NYXJjIFRob21wc29uMScwJQYJKoZIhvcNAQkBFhhtdGhvbXBzb25AbWVkaWEudXRhaC5lZHUxJTAjBgkqhkiG9w0BCQEWFm1hcmMudGhvbXBzb25AdXRhaC5lZHUwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAM59JRdQxO5rxD9dkmKAk/FobjsVKTA+u4e8lYfiMt3ZRIpBx5JX3h9h7j2JCZDPbB5s/jxg+DoL4oyL8nRZ5WI03nkWsizq4LzvPCudQjos5hflS+7sQNBUHJoUtQ+hX0vp4QmRs7qDlZ+zB3SgBz8YGOcQm1uDf++BS7wv89VFAgMBAAGjTTBLMDsGA1UdEQQ0MDKBGG10aG9tcHNvbkBtZWRpYS51dGFoLmVkdYEWbWFyYy50aG9tcHNvbkB1dGFoLmVkdTAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBAC8toPH9c2T1yBdVk/3XP3xeXtECE1Kin0w50pjBajicub5R6pz9jc+NhlpNPmcqVj3VVimTyFeFY97p3BrcjW3qPFp/KM5OabdIz4gLDT0aMzdjI0qo59DolQGSlPxRPU6RqMJRIJ0X75EhDhCgpDWy7UtVPInv5T4rAkLPskeBMIICvzCCAiigAwIBAgIQGwmO12ugrpsPpAU6Om7dsjANBgkqhkiG9w0BAQUFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDkwMjIzMTkzOTI1WhcNMTAwMjIzMTkzOTI1WjCBijERMA8GA1UEBBMIVGhvbXBzb24xDTALBgNVBCoTBE1hcmMxFjAUBgNVBAMTDU1hcmMgVGhvbXBzb24xJzAlBgkqhkiG9w0BCQEWGG10aG9tcHNvbkBtZWRpYS51dGFoLmVkdTElMCMGCSqGSIb3DQEJARYWbWFyYy50aG9tcHNvbkB1dGFoLmVkdTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAzn0lF1DE7mvEP12SYoCT8WhuOxUpMD67h7yVh+Iy3dlEikHHklfeH2HuPYkJkM9sHmz+PGD4OgvijIvydFnlYjTeeRayLOrgvO88K51COizmF+VL7uxA0FQcmhS1D6FfS+nhCZGzuoOVn7MHdKAHPxgY5xCbW4N/74FLvC/z1UUCAwEAAaNNMEswOwYDVR0RBDQwMoEYbXRob21wc29uQG1lZGlhLnV0YWguZWR1gRZtYXJjLnRob21wc29uQHV0YWguZWR1MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEFBQADgYEALy2g8f1zZPXIF1WT/dc/fF5e0QITUqKfTDnSmMFqOJy5vlHqnP2Nz42GWk0+ZypWPdVWKZPIV4Vj3uncGtyNbeo8Wn8ozk5pt0jPiAsNPRozN2MjSqjn0OiVAZKU/FE9TpGowlEgnRfvkSEOEKCkNbLtS1U8ie/lPisCQs+yR4EwggM/MIICqKADAgECAgENMA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIC8DCCAuwCAQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBsJjtdroK6bD6QFOjpu3bIwCQYFKw4DAhoFAKCCAdAwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDkxMjE2MjM0NDMyWjAjBgkqhkiG9w0BCQQxFgQUgGWYj3mOegu6Fujh2gSvEIMZ20swXwYJKoZIhvcNAQkPMVIwUDALBglghkgBZQMEAQIwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMIGFBgkrBgEEAYI3EAQxeDB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQGwmO12ugrpsPpAU6Om7dsjCBhwYLKoZIhvcNAQkQAgsxeKB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQGwmO12ugrpsPpAU6Om7dsjANBgkqhkiG9w0BAQEFAASBgCTYCRbwilXXD6Gqf85MSsEwJ+00NsF5w62XDcbQmF0gH13+Y5TK1S3+veR68AaNfEzHbTUUNdTCYPjWADdNyGLB69D8o0khtjV2n6lOxiKntx7wYQi3FXzo/t+V4YlIxSue4z1U31YENemOgGq5QfGAfJcpobRIh7PnGPMMZS5cAAAAAAAA--------------ms070007070607060404040807-- Associated Messages, from the most recent to the oldest:

Fwd: [WebDNA] Need to convert unix date? (William DeVaul 2011)
Re: [WebDNA] Need to convert unix date? (Donovan Brooke 2009)
Re: [WebDNA] Need to convert unix date? (Donovan Brooke 2009)
Re: [WebDNA] Need to convert unix date? (Marc Thompson 2009)
Re: [WebDNA] Need to convert unix date? (christophe.billiottet@webdna.us 2009)
Re: [WebDNA] Need to convert unix date? (Govinda 2009)
Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
Re: [WebDNA] Need to convert unix date? ("Terry Wilson" 2009)
Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
Re: [WebDNA] Need to convert unix date? (Stuart Tremain 2009)
Re: [WebDNA] Need to convert unix date? (Brian Fries 2009)
Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
Re: [WebDNA] Need to convert unix date? (Bob Minor 2009)
Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
Re: [WebDNA] Need to convert unix date? (Marc Thompson 2009)
Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
Re: [WebDNA] Need to convert unix date? (Marc Thompson 2009)
Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
[WebDNA] Need to convert unix date? (David Bastedo 2009)

This is a cryptographically signed message in MIME format.--------------ms070007070607060404040807Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: 7bitTry looking here:http://docs.webdna.us/MajorGroups.htmlCheck the "Dates & Times" section...MarcDavid 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:

> >> >> >> > > >>> >> > >

DOWNLOAD WEBDNA NOW!

Re: [WebDNA] Need to convert unix date?

2009

Top Articles:

Related Readings: