Convert unix time to date/time in Access 2003 for a linked tabel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin Joyce - 12 Apr 2005 13:34 GMT

Along time age I had a database that I used to access that used linked
tables and I was able to convert the the unix time value to a date/time
format but since upgrading to Access 2003 I have not been able to do this.

Can anyone provide some assistance?

Thanks.

Reply to this Message

Douglas J. Steele - 13 Apr 2005 17:54 GMT

How are you trying to convert the time? What happens when you try?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Along time age I had a database that I used to access that used linked
> tables and I was able to convert the the unix time value to a date/time
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message

Kevin Joyce - 18 Apr 2005 21:21 GMT

Hi Douglas,

I am connecting to a MySQL database. The field I am trying to convert is
called dtime it is in seconds since 1/1/1970. I am using:

DateAdd("s", [dtime], #1/1/1970 5:00:00#)

It is still reporting it in seconds when I execute my query.

Thanks.

> How are you trying to convert the time? What happens when you try?
>
[quoted text clipped - 5 lines]
> >
> > Thanks.

Reply to this Message

Douglas J. Steele - 18 Apr 2005 22:56 GMT

That looks as though it should work. What are you doing with the resultant
field?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi Douglas,
>
[quoted text clipped - 17 lines]
>> >
>> > Thanks.

Reply to this Message

John Nurick - 19 Apr 2005 06:53 GMT

As Doug says, that looks as if it should work - but it returns a date
serial number, not a string representation of a date (though VBA often
displays it as the latter). Are you sure it's giving you a Unix date in
seconds as opposed to an Access one in days?

>Hi Douglas,
>
[quoted text clipped - 17 lines]
>> >
>> > Thanks.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message