two steps ...
1. Use odbccreatedatetime() so that you have an ODBC object with both date and time, otherwise all Access gets is a date.
2. Use cf_sql_timestamp (you are using cfqueryparam, right?), so that the ODBC driver understands it's getting a date-time parameter.
Ta da! Date and time in your Access database.
A profile of zlionsfan
- zlionsfan
- Indiana, United States
- I like cats. I play a lot of games. Sometimes I develop web-based applications; this keeps my current employer from firing me too often. My favorite color is blue, or maybe green.
No comments:
Post a Comment