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:

Off Topic: Frames Killer? (1998) Now you see it now you donīt (1997) Why do extra quotation marks sometimes appear in my databases? (1998) b12 cannot limit records returned and more. (1997) Trying to loop for letters (1999) NT version (1997) RE: Formulas.db + Users.db (1997) HomePage Caution (1997) Hosts who have upgraded to v5.0? (2003) list/menus (2000) Date sorting (1997) Pithy questions on webcommerce & siteedit (1997) Typhoon Rev. and PCS store problems (1999) RE: High ASCII inside [LOOKUP] inside [LISTWORDS] (1998) [WebDNA] Calculate Cube root (2012) carriage returns in data (1997) Comments in db? (1997) WebCat2 beta 11 - new prefs ... (1997) too many files! (2006) Date problems-more (1997)