[AccessD] [Fwd: Re: Date Field]

Hi Rocky,

If the Unix Epoch date represents a number of seconds from a magic
point in time, how about if if you did a dateadd function with the
field containing the number of seconds to added the magic date with
the result being the date in date format from where you can store it
or do further fun stuff with it.. It would be something like

OutputDateField = DateAdd("s", lngUnixEpochDateInput, "1/1/1970")

Dateadd is described here...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctdateadd.asp

That is what I would probably do anyway.

GK

On 4/27/06, Rocky Smolin - Beach Access Software <bchacc at san.rr.com> wrote:
> Dear List:
>
> According to my web developer, the referral date in my affiliate program
> is being stored as "time measured in the number of seconds since the
> Unix Epoch (January 1 1970 00:00:00 GMT). Most programing
> languages/scripting languages will have functions to parse it and turn
> it into human readable time."
>
> Is there such a VBA function?
>
> MTIA
>
> Rocky
>
> -------- Original Message --------
> Subject:        Re: Date Field
> Date:   Thu, 27 Apr 2006 14:00:58 -0700 (PDT)
> From:   Sergey Kushch <skushch at parasitehosting.com>
> To:     Rocky Smolin - Beach Access Software <bchacc at san.rr.com>
> References:     <4450E5F3.8090100 at san.rr.com>
>
>
>
> Rocky,
>
> That is stored in a common computer way to storing time: the time measured
> in the number of seconds since the Unix Epoch (January 1 1970 00:00:00
> GMT). Most programing languages/scripting languages will have functions to
> parse it and turn it into human readable time. It is convenient to store
> dates like that because it is really easy to do queries for date ranges or
> sorting the values.
>
> What do you use to create the reports?
>
> - Sergey
>
> > Sergey:
> >
> > In the table affiliate_traffic the date field appears to be encoded
> > somehow.  How do I extract the date from that field?
> >
> > Thanks and regards,
> >
> > Rocky
> >
> > --
> > Rocky Smolin
> > Beach Access Software
> > 858-259-4334
> > www.e-z-mrp.com
> >
> >
>
>
>
> --
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com