A way to get the date serial (13 digit numeric)?

[Alp Bekisoglu]

Hi all, I guess there should be a way to obtain the date serial as the 13(I
might be wrong with the count) digit numeric value but could not find how to
get it so far.

Any information would be appreciated.

Thanks in advance,

Sincerely,

Alp

 

[MacDermott]

2 digits for month, 2 digits for day - even with 4 digits for year, we're
nowhere near 13.
What is it exactly that you're looking for?

- Turtle

 

[Alp Bekisoglu]

I should have been a bit more specific, sorry. I am refering to the numeric
string that underlies the date calculations, the one that is supposed to be
the actual time in seconds (or something similar) since ???

As far as I know, all date/time calculations are based on such value. Like
Now() or Today() bases the output to that particular value I think. Oracle
has that to mark an entry with the system date/time stamp.

I hope I did mention some of the correct terminology.

Alp

 

[Alp Bekisoglu]

To be more exact:

A UDate is a scalar value that indicates a specific point in time,
independent of calendar system and local time zone. It is stored as the
number of milliseconds from a reference point known as the epoch. The epoch
is midnight Universal Time Coordinated (UTC) January 1, 1970 A.D.

I think UNIX uses such format aswell.

Alp

 

[Marshall Barton]

Hi all, I guess there should be a way to obtain the date serial as the 13(I
might be wrong with the count) digit numeric value but could not find how to
get it so far.

Dates in Access are internally stored in a Double as the
number of days and fraction of a day since 30 Dec 1899.

I believe your imported "epoch" date is the number of
seconds (not milliseconds) since 1/1/1970. If you want to
convert from an Access date to your "epoch" date, use an
expression like this:

epochdate = DateDiff("s", #1/1/1970#, accessdate)

which is the "reverse" of the expression I posted in your
earlier thread:

accessdate = DateAdd("s", epochdate, #1/1/1970#)

It would be a lot easier for all of the folks following this
discussion if you would post followup questions to the
original thread instead of starting a new thread.