Hardline
Posts: 24
|
Posted: 12/02/2009, 9:23 AM |
|
This has been the bane of my existence for a while now.
When inserting incomplete dates into a database, like "9:05 AM", CodeCharge converts the month, date and year to "0001-1-1" in place of using the current date. When the data is submitted, the current date is captured with the user-specified time, constructing a valid date, but when the insert or update statements are built, CodeCharge trashes the date portion and replaces it with "0001-01-01". So, the update query fails every single time.
Maybe I'm doing something wrong, but this seems like a no-brainer. Anyway, I'd like to see this fixed.
I'm using the date mask "H:nn" and SQL Server 2005.
|
|
|
|