AW: [AccessD] Seconds Missing

Michael Brösdorf michael.broesdorf at web.de
Mon Jul 19 07:21:58 CDT 2004


How exactly are you trying to write the time to sql server (ODBC/Linked
table, ADO, etc.)?

Michael

-----Ursprüngliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Martin Caro
Gesendet: Montag, 19. Juli 2004 13:30
An: Access Developers discussion and problem solving
Betreff: [AccessD] Seconds Missing


Hi Folks

I have spent some time in the archives and reviewing past date/time issues
looking for a fix for this problem: I grab the user login time using NOW()
and save it to an SQL table however any seconds apparent in Access always
end up as :00 being save in my SQL table. I was using smalldatetime data
type which I changed to datetime but without success. I have played with
Format() a bit but maybe someone knows where my seconds have gone?

Martin

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list