RE: odd Date

2003-06-20 Thread Jay Blanchard
[snip] insert into OrdenServicio set folioOrdenServicio='', idCanal='1', idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no prende', idEntregaControl='1', numSerie='7349843', estaComponenteBase='1', observaciones='', idStatusOrden='7', idCanalLevantamiento='1', idTiendaLevant

Re: odd Date

2003-06-20 Thread Miguel Perez
Hi: The weird thing is that not always do the same, I mean I always introduce that insert query, but not always inserts a wrong date, sometimes the date is correct. Mikel From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> CC: "Miguel Perez" <

Re: odd Date

2003-06-20 Thread Roger Baklund
* Miguel Perez > I have the following problem: > > When I insert a date in my table, and after do the insert I select the > column date to see if the date is right but it displays the date like > follows: > > 2019-06-20 > > When the original insert is: > > 2003-06-19 You would get this resul

RE: odd Date

2003-06-20 Thread Miguel Perez
on` varchar(255) NOT NULL default '', `colorProducto` varchar(50) NOT NULL default '', `esGarantiaReparacion` tinyint(1) NOT NULL default '0', PRIMARY KEY (`folioOrdenServicio`), From: "Jay Blanchard" <[EMAIL PROTECTED]> To: "Miguel Perez" <

RE: odd Date

2003-06-20 Thread Jay Blanchard
[snip] insert into OrdenServicio set folioOrdenServicio='', idCanal='1', idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no prende', idEntregaControl='1', numSerie='7349843', estaComponenteBase='1', observaciones='', idStatusOrden='7', idCanalLevantamiento='1', idTiendaLevant

RE: odd Date

2003-06-20 Thread Miguel Perez
, idLinea='1', esReparacionInterna='', otroAccesorio='', idFalla='0', idTaller='1', idCentroServicio='0', fechaLevantamiento='2003-06-19', lada='', ubicacion='', colorProducto='', esGarantiaReparacion='1

RE: odd Date

2003-06-20 Thread Jay Blanchard
[snip] When I insert a date in my table, and after do the insert I select the column date to see if the date is right but it displays the date like follows: 2019-06-20 When the original insert is: 2003-06-19 [/snip] Please show us your insert query. Jay -- MySQL General Mailing List For lis

odd Date

2003-06-20 Thread Miguel Perez
Hi: I have the following problem: When I insert a date in my table, and after do the insert I select the column date to see if the date is right but it displays the date like follows: 2019-06-20 When the original insert is: 2003-06-19 I looked into the manual to figure out how mysql works w