Terry
On Th=u, 17 Dec 2009 10:13:48 +1100
Stuart Tremain<webdna@idfk.com.au> wrote:
> Very nice job Brian
>
> It gives me an idea for some other stuff....
>
>
> Regards
>
> Stuart Tremain
> IDFK Web Developments
>AUSTRALIA
> webdna@idfk.com.au
>
>
>
> <=br>> On 17/12/2009, at 9:53 AM, Brian Frieswrote:
>
>> As my holiday gift to the list, see the attac=hed WebDNA
>>function library,"brainepoch.lib".
>>
>> This library contains WebDNA f=unctions for working with
>>timestamps (seconds since WebDNA zero date or 1/1/0000)
&=gt;>and Unix Epoch (seconds since Unix zerodate of
>>1/1/1970).
>>
>> The functions inc=lude:
>>
>>bepVersion-Returns version code for this library
>>release=
>> bepFunctions-Returns list offunction names
>>supported by this library release
>> =bepGMTOffset-Return Hours from GMT to localtime
>> 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 v=alue
>> bepTimestampDayRange-Returnsearch rn value for a day
>>or range of days
>> bepEp=och-Seconds since Unix epoch(1/1/1970)
>> bepEpochDate-Return Date component of a bepEpo=ch
>>value
>>bepEpochTime-Return Time component of a bepEpoch
>>value
>> bepEpochDayRange-Return search rnvalue for a day or
>>range of days
>> bepCartEpoch-=Generate Epoch from Cart value
>>bepCartGMTOffset-Generate GMT Offset from current
>>cart val=ue
>> bepCartDate-Return Date,extracted from Cart ID
>> bepCartTime-Return Time, extracte=d from Cart ID
>>
>>
>> The source code is fairly thoroughly documented, so you
=>>can read the comments above eachfunction to learn how to
>>use them appropriately.
>> =
>> One part that's not obvious isthat you should first
>>(one time only) call the "bepSetGMTOffs=et" function to
>>save your system'sGMT offset preference for future use.
>>
>> Happy holi=days!
>>
>> BrianFries
>> BrainScan Software
>>
>> P.S. Good f=olks at WebDNA corp: Feel free to post this
>>to your downloads section.
>>
>> On Dec 16=, 2009, at 2:13 PM, David Bastedowrote:
>>
>>> what does: Math to use Date Display F=ormat? do in the
>>>config? it isset 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!
&g=t;>>
>>> On Dec 16, 2009, at3:58 PM, Dan Strong wrote:
>>>
>>> > What is =your date format set to in your WebDNA admin?
>>>Mine is "Month/Date/Year (American)"?
>>> >=;
>>> > -DanStrong
>>> > 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
>>>theyear. I have
>>> >> tried it on two different servers, =so I am not sure
>>>what isup.
>>> >>
>>> >> -----
>>&g=t; >>
[math]val=3D1252257406*1[/math] =3D[math
>>>date]{01/01/1970} + {[format
>>> >&g=t; 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 stampto:
>>> >>
>>> >>
>>> >=;> [Math
>>> >>
>>>show=3Df]subTotal=3D
[math]{09/14/2009}[/math]-
[math]{01/0=1/1970}[/math][/math]
>>> >>total time + days + 1 day - 5 hours
>>> >>
>>=>=3D
[math]([subTotal]*86400)+{06:08:54}+86400-18000[/math]=3D
>&=gt;>>> [reaction_published]
>>> >>
>>> &g=t;> so technically, if I do this in thereverse, I should
>>>get what I need . . .
>>> &=gt;>
>>> >>d.
>>> >>
>>> >>
>>> >=>
>>> >>
>>>>>
>>> >>
>>> >> On Wed, Dec 16=, 2009 at 4:01 PM, Marc Thompson
>>><mthompson@media.utah.edu
>>> >> <=;mailto:mthompson@media.utah.edu>>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, whi=ch is -7DST.
>>>>>
>>> >> You would need to add some more form=atting code to
>>>get it in theform
>>> >> you show in your previous post.
>&=gt;> >> ie. The timestamp1252976934 corresponds to
>>>2009/09/14 06:08:54 pm PDT.
=>>> >>
>>> >>=20 Marc
>>> >>
>>> >> David Bastedo= wrote:
>>> >> >Unfortunately, I get: 09/16/3909 with the code
>>>below:
>>> >> >
>>>>> > I'm trying to work through this . . .
>>> &=gt;> >
>>> >> =20> d.
>>> >> >
>>> >> &g=t;
>>> >> > On Wed,Dec 16, 2009 at 11:17 AM, Marc Thompson
>>> >> >= <mthompson@media.utah.edu
>>><mailto:mthompson@media.utah.edu>
>>> &=gt;> <mailto:mthompson@media.utah.edu
>>><mailto:mthompson@media.utah.edu>>>
>&g=t;> >> wrote:
>>>>> >
>>> >> > Here you go:
&=gt;>> >> >
>>>>> >
[math]val=3D1252976934*1[/math] =3D [math
>&=gt;>date]{01/01/1970} +
>>> >> {[format
>>> >> > days_to_date %m/%d/%Y][=format
>>> >> >
>>> .6d]
[math]([val]/86400)+1[/math][/format][/format]}[/=math]
>>> >> =20>
>>> >> > Marc
>>> >> = >
>>> >> > =20David Bastedo wrote:
>>> >> > > The timestamp= *1252976934* corresponds to*
>>>2009/09/14 06:08:54 pm
>>> >> > = PDT*.
>>> >> >>
>>> >> > > this is the time stamp: *1252=976934*
>>> >> >>
>>> >> > > [format days_to_date %m/%d/%Y=][format
>>> >> > >
>>>.6d]
[math]([your_UNIX_timestamp]/86400)+1[/math][/format]=[/format]
>>> >> >>
>>> >> > > gets me: 09/16/39
>>=> >> > >
>>>>> > > d.
>>> >> > >
>&=gt;> >> > > On Tue, Dec 15,2009 at 6:54 PM, Dan Strong
>>> >> <webdna@danstr=ong.com
>>><mailto:webdna@danstrong.com>
>>&g=t;>> > <mailto:webdna@danstrong.com
>>><mai=lto:webdna@danstrong.com>>
>>>>> > > <mailto:webdna@danstrong.com
>>>&l=t;mailto:webdna@danstrong.com>
>>>>> <mailto:webdna@danstrong.com
>>><mailto:we=bdna@danstrong.com>>>>wrote:
>>> >> > >
>>> >> = > > Try this:
>>>>> > >
>>> >> > > [format= days_to_date %m/%d/%Y][format
>>>>> > >
>>> >>
>>> .6d][m=ath]([your_UNIX_timestamp]/86400)+1[/math][/format][/format]
>>&=gt;>> > >
>>> >> > >
>>=> >> > >
>>>>> > > On 12/15/2009 3:47 PM, David Bastedo
>&=gt;>wrote:
>>> >> >>
>>> >> > > Hi, I need to convert= a date stored
>>>in unix format-
>>> >> seconds
>>> >> > &=gt; since Jan
>>> >>=20 > > 01, 1970. Is there a formula or
>>>func=tion that anybody
>>> >> =20> might have?
>>> >> > >
>>&g=t; >> > > I am pullingin an xml file generated
>>>by an external
>>> &=gt;> api and
>>> >> =20> > that date
>>> >> > > = comes in this format.
>>>>> > >
>>> >> > > tha=nks.
>>> >> >>
>>> >> > > d.
>>> &g=t;> > >
>>> >> =20 > >
>>> >> > > --
>>=> >> > > DavidBastedo
>>>
>> <brainepoch.zip>
>
<=br>=A0