Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Converting Unix Timstamps into a Standard Date using Access

1 view
Skip to first unread message

Bryan Brannigan

unread,
Jan 15, 2003, 10:04:56 AM1/15/03
to
I have a MySQL database that stores the Date/Time as a Unix Timestamp.
I am in the process of creating reports using this database and MS
Access. I have found a few functions and solutions in the groups to
convert this timestamp into something useable for Access, but cannot
get any of them to work. Can anyone enlighten a Access newbie like
myself as to what I may be able to do?

Douglas J. Steele

unread,
Jan 15, 2003, 6:36:04 PM1/15/03
to
If I'm not mistaken, the Unix Timestamp is the number of seconds since
midnight, 1 Jan, 1970.

That means you should be able to convert them as DateAdd("s", UnixTimeStamp,
#1/1/1970#)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele


"Bryan Brannigan" <bbra...@maine.rr.com> wrote in message
news:603c3ec8.0301...@posting.google.com...

Bryan Brannigan

unread,
Jan 16, 2003, 8:49:59 AM1/16/03
to
So my next question would be, is it possible to go the other way. I
want to enter a date in normal format (01/16/2003) and be able to
convert that back to a Unix timestamp to filter my query.

"Douglas J. Steele" <djst...@canada.com> wrote in message news:<EfmV9.346252$F2h1....@news01.bloor.is.net.cable.rogers.com>...

Douglas J. Steele

unread,
Jan 16, 2003, 7:48:13 PM1/16/03
to
DateDiff("s", #1/1/1970#, MyDate)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele


"Bryan Brannigan" <bbra...@maine.rr.com> wrote in message

news:603c3ec8.03011...@posting.google.com...

0 new messages