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

Reply via email to