Are you exporting/importing the DDL as well? Is the column type the same for
both tables?
What is that column type? TIMESTAMP(14)?
-Original Message-
From: Fajar Priyanto
To: Victor Pendleton; '[EMAIL PROTECTED] '
Sent: 4/20/04 9:16 AM
Subject: Re: error importing date
as well? Is the column type the
same
> for both tables?
> What is that column type? TIMESTAMP(14)?
>
> -Original Message-
> From: Fajar Priyanto
> To: Victor Pendleton; '[EMAIL PROTECTED] '
> Sent: 4/20/04 9:16 AM
> Subject: Re: error importing date
>
Fajar Priyanto <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> I encounter this error when importing database from one mysql server into=20
> another: the date imported is wrong. The type is timestamp.
>
> In the dump file, the date is : 0404121921, but when imported, it becomes:=
> 0004041219.
>
> Cou
the same
> for both tables?
> What is that column type? TIMESTAMP(14)?
>
> -Original Message-
> From: Fajar Priyanto
> To: Victor Pendleton; '[EMAIL PROTECTED] '
> Sent: 4/20/04 9:16 AM
> Subject: Re: error importing date
>
> Hi Victor, thanks for respon
g '00' at the end of every
timestamp.
On Tuesday 20 April 2004 08:49 pm, Victor Pendleton wrote:
> How are you exporting/importing the data?
>
> -Original Message-
> From: Fajar Priyanto
> To: [EMAIL PROTECTED]
> Sent: 4/20/04 3:51 AM
> Subject: error impor
How are you exporting/importing the data?
-Original Message-
From: Fajar Priyanto
To: [EMAIL PROTECTED]
Sent: 4/20/04 3:51 AM
Subject: error importing date
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I encounter this error when importing database from one mysql server
into
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I encounter this error when importing database from one mysql server into
another: the date imported is wrong. The type is timestamp.
In the dump file, the date is : 0404121921, but when imported, it becomes:
0004041219.
Could anybody pls g