I am using a CRecordSet class in which there is a
I am connecting to an Access database and one of the field is date time (general Long in access)
Now when I retrive the date
m_pSet->m_time.GetHour() always gives me 19
m_pSet->m_time.GetMinute() always gives me 0
I am using ODBC
But if I create the same table in SQL server and use the same program just changing DSN I get the correct hour and mins in the database field.
Anybody has an idea what problem with access I might be having?
To summarise :
If I want to exchange the CTime var in RFX_date(..)
with a time field in ACCESS what is the correct access time/date datatype should I be using or are they not compatible?
Running out of points so please bear with 50 points although this deserves more points.