Re: [WebDNA] Need to convert unix date?

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 104190
interpreted = N
texte = --Apple-Mail-13--769812949 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Very nice job Brian It gives me an idea for some other stuff .... Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 17/12/2009, at 9:53 AM, Brian Fries wrote: > As my holiday gift to the list, see the attached WebDNA function = library, "brainepoch.lib". >=20 > This library contains WebDNA functions for working with timestamps = (seconds since WebDNA zero date or 1/1/0000) and Unix Epoch (seconds = since Unix zero date of 1/1/1970). >=20 > The functions include: >=20 > bepVersion-Returns version code for = this library release > bepFunctions-Returns list of function names = supported by this library release > bepGMTOffset-Return Hours from GMT to local = time > bepSetGMTOffset-Set value of GMT Offset > bepEpochDays-Days from WebDNA epoch = (1/1/0000) to Unix epoch (1/1/1970) > bepTimestamp-Seconds since WebDNA epoch = (1/1/0000) > bepTimestampDate-Return Date component of a = bepTimestamp value > bepTimestampTime-Return Time component of a = bepTimestamp value > bepTimestampDayRange-Return search rn value for a day or = range of days > bepEpoch-Seconds since Unix epoch = (1/1/1970) > bepEpochDate-Return Date component of a = bepEpoch value > bepEpochTime-Return Time component of a = bepEpoch value > bepEpochDayRange-Return search rn value for a day = or range of days > bepCartEpoch-Generate Epoch from Cart value > bepCartGMTOffset-Generate GMT Offset from current = cart value > bepCartDate-Return Date, extracted = from Cart ID > bepCartTime-Return Time, extracted = from Cart ID >=20 >=20 > The source code is fairly thoroughly documented, so you can read the = comments above each function to learn how to use them appropriately. >=20 > One part that's not obvious is that you should first (one time only) = call the "bepSetGMTOffset" function to save your system's GMT offset = preference for future use. >=20 > Happy holidays! >=20 > Brian Fries > BrainScan Software >=20 > P.S. Good folks at WebDNA corp: Feel free to post this to your = downloads section. >=20 > On Dec 16, 2009, at 2:13 PM, David Bastedo wrote: >=20 >> what does: Math to use Date Display Format? do in the config? it is = set to no? >>=20 >> On Wed, Dec 16, 2009 at 5:08 PM, Bob Minor wrote: >> Works on my servers, must be a config issue! >>=20 >> On Dec 16, 2009, at 3:58 PM, Dan Strong wrote: >>=20 >> > 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=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 >> >> >> >> I have deconstructed the original time stamp to: >> >> >> >> >> >> [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] >> >> >> >> 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=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 >>=20 > --Apple-Mail-13--769812949 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Very = nice job Brian

It gives me an idea for some other = stuff ....


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 17/12/2009, at 9:53 AM, Brian Fries wrote:

As my holiday gift to the = list, see the attached WebDNA function library, = "brainepoch.lib".

This library contains WebDNA = functions for working with timestamps (seconds since WebDNA zero date or = 1/1/0000) and Unix Epoch (seconds since Unix zero date of = 1/1/1970).

The functions = include:

bepVersion= -= Returns version code for this library release
= bepFunctions-Returns = list of function names supported by this library release
= bepGMTOffset-Return = Hours from GMT to local time
bepSetGMTOffset= -= Set value of GMT Offset
bepEpochDays= -= Days from WebDNA epoch (1/1/0000) to Unix epoch = (1/1/1970)
bepTimestamp= -= Seconds since WebDNA epoch (1/1/0000)
= bepTimestampDate-Return Date component of a = bepTimestamp value
bepTimestampTime-Return = Time component of a bepTimestamp value
= bepTimestampDayRange-Return search rn value for a day = or range of days
bepEpoch= -= Seconds since Unix epoch (1/1/1970)
= bepEpochDate-Return = Date component of a bepEpoch value
= bepEpochTime-Return = Time component of a bepEpoch value
= bepEpochDayRange-Return search rn value for a day = or range of days
bepCartEpoch= -= Generate Epoch from Cart value
= bepCartGMTOffset-Generate GMT Offset from current = cart value
bepCartDate= -= Return Date, extracted from Cart ID
= bepCartTime-Return = Time, extracted from Cart ID


The = source code is fairly thoroughly documented, so you can read the = comments above each function to learn how to use them = appropriately.

One part that's not obvious is = that you should first (one time only) call the "bepSetGMTOffset" = function to save your system's GMT offset preference for future = use.

Happy holidays!

Brian = Fries
BrainScan Software
P.S. Good folks at WebDNA corp: Feel free to post this to = your downloads section.

On Dec 16, 2009, at 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 <bob@cybermill.com> = 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=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
>>
>> I have deconstructed the original time stamp to:
>>
>>
>> [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]
>>
>> 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 <mthompson@media.utah.edu
>> <mailto:mthompson@media.utah.edu>&= gt; 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
>>     > <mthompson@media.utah.edu = <mailto:mthompson@media.utah.edu><= br> >>    <mailto:mthompson@media.utah.edu = <mailto:mthompson@media.utah.edu>&= gt;>
>>    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>
>>     > <mailto:webdna@danstrong.com = <mailto:webdna@danstrong.com>>
>>     > > <mailto:webdna@danstrong.com = <mailto:webdna@danstrong.com>
>>    <mailto:webdna@danstrong.com = <mailto:webdna@danstrong.com>>>&= gt; 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

<brainepoch.zip>=

= --Apple-Mail-13--769812949-- 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)
--Apple-Mail-13--769812949 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Very nice job Brian It gives me an idea for some other stuff .... Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 17/12/2009, at 9:53 AM, Brian Fries wrote: > As my holiday gift to the list, see the attached WebDNA function = library, "brainepoch.lib". >=20 > This library contains WebDNA functions for working with timestamps = (seconds since WebDNA zero date or 1/1/0000) and Unix Epoch (seconds = since Unix zero date of 1/1/1970). >=20 > The functions include: >=20 > bepVersion-Returns version code for = this library release > bepFunctions-Returns list of function names = supported by this library release > bepGMTOffset-Return Hours from GMT to local = time > bepSetGMTOffset-Set value of GMT Offset > bepEpochDays-Days from WebDNA epoch = (1/1/0000) to Unix epoch (1/1/1970) > bepTimestamp-Seconds since WebDNA epoch = (1/1/0000) > bepTimestampDate-Return Date component of a = bepTimestamp value > bepTimestampTime-Return Time component of a = bepTimestamp value > bepTimestampDayRange-Return search rn value for a day or = range of days > bepEpoch-Seconds since Unix epoch = (1/1/1970) > bepEpochDate-Return Date component of a = bepEpoch value > bepEpochTime-Return Time component of a = bepEpoch value > bepEpochDayRange-Return search rn value for a day = or range of days > bepCartEpoch-Generate Epoch from Cart value > bepCartGMTOffset-Generate GMT Offset from current = cart value > bepCartDate-Return Date, extracted = from Cart ID > bepCartTime-Return Time, extracted = from Cart ID >=20 >=20 > The source code is fairly thoroughly documented, so you can read the = comments above each function to learn how to use them appropriately. >=20 > One part that's not obvious is that you should first (one time only) = call the "bepSetGMTOffset" function to save your system's GMT offset = preference for future use. >=20 > Happy holidays! >=20 > Brian Fries > BrainScan Software >=20 > P.S. Good folks at WebDNA corp: Feel free to post this to your = downloads section. >=20 > On Dec 16, 2009, at 2:13 PM, David Bastedo wrote: >=20 >> what does: Math to use Date Display Format? do in the config? it is = set to no? >>=20 >> On Wed, Dec 16, 2009 at 5:08 PM, Bob Minor wrote: >> Works on my servers, must be a config issue! >>=20 >> On Dec 16, 2009, at 3:58 PM, Dan Strong wrote: >>=20 >> > 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=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 >> >> >> >> I have deconstructed the original time stamp to: >> >> >> >> >> >> [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] >> >> >> >> 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=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 >>=20 > --Apple-Mail-13--769812949 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Very = nice job Brian

It gives me an idea for some other = stuff ....


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 17/12/2009, at 9:53 AM, Brian Fries wrote:

As my holiday gift to the = list, see the attached WebDNA function library, = "brainepoch.lib".

This library contains WebDNA = functions for working with timestamps (seconds since WebDNA zero date or = 1/1/0000) and Unix Epoch (seconds since Unix zero date of = 1/1/1970).

The functions = include:

bepVersion= -= Returns version code for this library release
= bepFunctions-Returns = list of function names supported by this library release
= bepGMTOffset-Return = Hours from GMT to local time
bepSetGMTOffset= -= Set value of GMT Offset
bepEpochDays= -= Days from WebDNA epoch (1/1/0000) to Unix epoch = (1/1/1970)
bepTimestamp= -= Seconds since WebDNA epoch (1/1/0000)
= bepTimestampDate-Return Date component of a = bepTimestamp value
bepTimestampTime-Return = Time component of a bepTimestamp value
= bepTimestampDayRange-Return search rn value for a day = or range of days
bepEpoch= -= Seconds since Unix epoch (1/1/1970)
= bepEpochDate-Return = Date component of a bepEpoch value
= bepEpochTime-Return = Time component of a bepEpoch value
= bepEpochDayRange-Return search rn value for a day = or range of days
bepCartEpoch= -= Generate Epoch from Cart value
= bepCartGMTOffset-Generate GMT Offset from current = cart value
bepCartDate= -= Return Date, extracted from Cart ID
= bepCartTime-Return = Time, extracted from Cart ID


The = source code is fairly thoroughly documented, so you can read the = comments above each function to learn how to use them = appropriately.

One part that's not obvious is = that you should first (one time only) call the "bepSetGMTOffset" = function to save your system's GMT offset preference for future = use.

Happy holidays!

Brian = Fries
BrainScan Software
P.S. Good folks at WebDNA corp: Feel free to post this to = your downloads section.

On Dec 16, 2009, at 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 <bob@cybermill.com> = 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=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
>>
>> I have deconstructed the original time stamp to:
>>
>>
>> [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]
>>
>> 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 <mthompson@media.utah.edu
>> <mailto:mthompson@media.utah.edu>&= gt; 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
>>     > <mthompson@media.utah.edu = <mailto:mthompson@media.utah.edu><= br> >>    <mailto:mthompson@media.utah.edu = <mailto:mthompson@media.utah.edu>&= gt;>
>>    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>
>>     > <mailto:webdna@danstrong.com = <mailto:webdna@danstrong.com>>
>>     > > <mailto:webdna@danstrong.com = <mailto:webdna@danstrong.com>
>>    <mailto:webdna@danstrong.com = <mailto:webdna@danstrong.com>>>&= gt; 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

<brainepoch.zip>=

= --Apple-Mail-13--769812949-- Stuart Tremain

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) executive server side java within webDNA (1997) Help name our technology! (1997) Separate SSL Server (1997) UPS Rate Tool (hit and miss) (2003) [WebDNA] Google map mashups (2010) Q: old cart serial problem (2000) New Guestbook Source (1997) Vann's - nice new WebCatalog site (1998) Repost paging through results detail view (2003) Server crash (1997) Help! WebCat2 bug (1997) Sorting by SKU Not Working (1998) [WebDNA] Stop & Start WebDNA (2020) [include] and not found (2005) Clean Code: Rules for inserting keyboard returns? (1997) Location of Browser Info.txt file (1997) hidden databases (2000) Banner DNA (1997) PCS Frames (1997)