This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
1. Connect to Java DB 'table'. 2. Rightclick table 'trip' and choose "View Data...". 3. Press "Insert Record" button. 4. Add necessary data and set value for field with type TIMESTAMP (or DATE) value as it shown in results for other records. Result: "Enter valid data ..." message appears.
Use ISO Date format, it should work; Time: HH:mm:ss Date: yyyy-MM-dd MM-dd-yyyy DateTime: yyyy-MM-dd HH:mm:ss.SSS yyyy-MM-dd HH:mm:ss
I made this issue an ENHANCEMENT. It will be much easier for customers to enter value as they see it in result. So it will be better to implement converting of date types to ISO date format. User enters value in format, which is displayed in results, and then this format should be converted to ISO date. In this case it will be much more WYSIWYG.
This behavior is similar to what you see in Excel or Open Office. I don't think there is any easy way to do this. Also, I don't think its worth spending time to parse the formatted datetime string.
I think what we are doing is correct, there is no need to enhance this further.
Ahi, you can spend time on this later, probably not for 6.5. And it doesn't matter that Excel and Open Office behave similar. We should make better IDE and only in this case customers will choose our product. And note, this is an ENHANCEMENT, not a DEFECT. If you totally disagree, please send an email to alias and ask if this is good enhancement. If most of the people think that it's bad idea, then I won't insist anymore. ;)
I do disagree with you, but I will leave this alone. Marking as P4
Fixed.
Verified with build 081218.