Subject | Date-Time Bug |
---|---|
Author | Rick Fincher |
Post date | 2002-11-14T01:40:24Z |
Hi All,
Tested out todays cvs build for date and time and found that the times are
off by 12 hours for times read from the database. AM times show up as PM
and PM times as AM. The the date, hours, minutes, and seconds seem to be
correct otherwise.
Times written into the database are formatted correctly. If I write 9:00 AM
to a date field with my Java app, then look at the table with FBWorkbench,
it shows up as 9:00 AM.
When I read the same field with the Java app, it is returned as 9:00 PM.
Sorry, I don't have any 24 hour format examples to check handy. It looks
like this is an AM/PM formatting error and may not show up in times in 24
hour format.
Rick
Tested out todays cvs build for date and time and found that the times are
off by 12 hours for times read from the database. AM times show up as PM
and PM times as AM. The the date, hours, minutes, and seconds seem to be
correct otherwise.
Times written into the database are formatted correctly. If I write 9:00 AM
to a date field with my Java app, then look at the table with FBWorkbench,
it shows up as 9:00 AM.
When I read the same field with the Java app, it is returned as 9:00 PM.
Sorry, I don't have any 24 hour format examples to check handy. It looks
like this is an AM/PM formatting error and may not show up in times in 24
hour format.
Rick