Re: Access, MyODBC, MySQL Questions .....


Malcolm Cook wrote:

Make sure your timestamps have values. It seems that adding a
timestamp does not undersome circumstances give the field a value.

Set the Timestamp field default value to CURRENT_TIMESTAMP and it will store the current date/time in the field. This is different than the SQL Server Timestamp field which automatically stores a binery representation of the current date/time that is not user usable.

--
Bri

.

Relevant Pages

  • Re: Migration of Teradata and DB2 Timestamp fields.
    ... There is no datatype in SQL Server that has a precision of 1 millisecond. ... - Store the timestamp in a CHARcolumn in format ... Note that the precision will go back to 3.33 milliseconds when you ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Difference between two dates and times
    ... Are these SQL Server tables? ... Access tables have a Date/Time ... >the table with the calculation using SQL. ... will work with TIMESTAMP values as well as Date/Time values but I'm ...
    (microsoft.public.access.queries)
  • Re: logging time spent on my website
    ... I store the timestamp in db ok thats cool. ... Thats why I was thinking of a endless loop. ... > you now have 2 items, last length of time, and current time stamp. ...
    (comp.lang.php)
  • Re: DCount distinct date/time based on date only
    ... I say *unique* because the field contains a date/time but I ... need to ignore the timestamp and work off the date only. ... SELECT MINAs EarliestClass FROM Attendance ... SELECT MIN) As EarliestClass FROM Attendance ...
    (comp.databases.ms-access)
  • Re: adding an interval to medium time control
    ... Date/Time values in Access are stored as 8 byte floating point numbers, ... If you're trying to store a duration, ... I have a control with ... field in the table formatted as medium time and the controls on the ...
    (microsoft.public.access.formscoding)