Bugzilla – Full Text Bug Listing
| Summary: | SQL - timestamp host variable formats as date rather than timestamp following fetch | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | z_Archived | Reporter: | Paul Hoffman <hoffmanp> | ||||||
| Component: | EDT | Assignee: | Project Inbox <edt.javagen-inbox> | ||||||
| Status: | CLOSED FIXED | QA Contact: | |||||||
| Severity: | normal | ||||||||
| Priority: | P3 | CC: | jvincens | ||||||
| Version: | unspecified | ||||||||
| Target Milestone: | --- | ||||||||
| Hardware: | PC | ||||||||
| OS: | Windows XP | ||||||||
| Whiteboard: | |||||||||
| Attachments: |
|
||||||||
Created attachment 206280 [details]
Lib for database loading
fixed verified and closed |
Created attachment 206279 [details] Test program Timestamp host variable formats as date rather than timestamp following fetch. Test output shown below. Be sure to download both test case and database load library. Test output: Start test to show that timestamp host variables format as date following fetch default get row, use string parameter to show timestamp aTimeStamp = 01/05/1970 aStringTimeStamp = 1970-01-05 00:00:00.000000 default get row, use timestamp parameter to show timestamp aTimeStamp = 01/05/1970 aStringTimeStamp = 1970-01-05 00:00:00.0 switch source columns on get, use string parameter to show timestamp aTimeStamp = 01/05/1970 aStringTimeStamp = 1970-01-05 00:00:00.000000 switch source columns on get, use timestamp parameter to show timestamp aTimeStamp = 01/05/1970 aStringTimeStamp = 1970-01-05 00:00:00.0