Access DB and DateTime

[idkpmiller]

I am having loads of grief with writing Date and Time into an AccessDB always a mismatch, has anyone done this before with a piece of code?

Google turns up quite a few hits but all seem to be workarounds by changing the field to a text, for now so I can move on I have done this bit I need to sort in descending order this could have been achieved by a simple query now its a pain in the @ss

Thanks

[sub]

Are you taking about passing a datetime parameter into a command? If so, it doesnt like the millisecond part of the date time fields, so I usually ended up constructing a temporary date that didnt contain the milliseconds.

Code:

updateRecordingCommand.Parameters[0].Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
updateRecordingCommand.Parameters[0].DbType = System.Data.DbType.DateTime;

[idkpmiller]

Hi sub,

I am actually trying to store the dateandtime a game is played in an access DB and that is what is causing the mismatch error report, its a .net to access issue really not a gbpvr thing, although its part of GameZone2.

[bgowland]

Post an example of your db code and where you're getting the type mismatch error and I'd be happy to look at it.

I know I've done this on a regular basis in the past (long time ago now) so I'll see if I can dig out my old source code.

Cheers,
Brian

[Ommina]

I think sub was just using that as an example of how he passes a time to an ADO.NET command object. (At least, that's how I interpreted it.) So it should still be OK for you.

Another random thought: Access needed dates (in SQL) surrounded by # signs, not the single quote that other implementations use. Of course, that won't help at all if you're not passing the date inside some sort of SQL, but thought I'd throw it out there.

[idkpmiller]

Thanks for the suggestions guys and offers of help, I sat back thought about it and approached from a different angle which worked fime :-)

Cheers