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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set the DateTimeMode property when filling a DataTable 3
Optimistic Concurrency and TimeStamp 4
How do I set the DateTimeMode property when filling a DataTable 1
Using a Timestamp field to implement optimistic concurrency 2
Dataset timestamp fails to update 1
>> sql timestamp 4
Timestamp Datatype issues 6
datacolumn datetime from UTC to Localtime 2

Back
Top