timestamp insert / update only stores date

  • Thread starter Thread starter David A. Schramm
  • Start date Start date
D

David A. Schramm

When I assign a DateTime value of Now to an MS Access Date/Time field, only
the date is stored. Anyone have an idea regarding how to get the whole
timestamp stored other than changing the SQL from an input parameter (?) to
Now()? I need to store GMT (UTC), not local time.
 
Hi David,

How are your parameters defined?
By default, wizard generates
OleDbType.DBDate
parameters for Date/Time field and those store only date portion.
Change the parameter type to
OleDbType.Date
and there you go.
 
¤ When I assign a DateTime value of Now to an MS Access Date/Time field, only
¤ the date is stored. Anyone have an idea regarding how to get the whole
¤ timestamp stored other than changing the SQL from an input parameter (?) to
¤ Now()? I need to store GMT (UTC), not local time.
¤

If you're still having a problem with this you may want to post your SQL code.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top