Package: mdbtools Version: 0.5.99.0.6pre1.0.20051109-7 Severity: normal While exporting a table from a Jet4 MS Access database, where values in a Date/Time field show as:
10/17/2010 12:23:38 AM in MS Access. After exporting this table with (shell syntax): mdb-export -D '%Y-%m-%d %H:%M:%S' ${MDBFILE} ${TABLE} The values show as: 2010-10-17 00:23:38 as expected. However, values of "10/17/2010", i.e. exactly at 00:00:00, or any time within the first hour of the day (between 00:00:00 and 01:00:00) then mdb-export converts this to: 2010-10-16 24:00:00 -- System Information: Debian Release: squeeze/sid APT prefers unstable APT policy: (990, 'unstable'), (500, 'testing-proposed-updates'), (500, 'testing'), (500, 'stable'), (1, 'experimental') Architecture: amd64 (x86_64) Kernel: Linux 2.6.32-5-amd64 (SMP w/4 CPU cores) Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages mdbtools depends on: ii libc6 2.11.2-7 Embedded GNU C Library: Shared lib ii libglib2.0-0 2.24.2-1 The GLib library of C routines ii libmdbtools 0.5.99.0.6pre1.0.20051109-7 mdbtools libraries ii libreadline6 6.1-3 GNU readline and history libraries mdbtools recommends no packages. mdbtools suggests no packages. -- no debconf information -- Sebastian Luque -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org