RE: Problem when insert date value in SQL Server

2003-03-24 Thread Illera, Fernando
, Fernando CC: [EMAIL PROTECTED] Asunto: Re: Problem when insert date value in SQL Server Illera, Fernando wrote: > Thanks Mac. > > I have tried as you recommended: > > my($now) = time(); Here's your problem. time() returns the number of seconds since the epoch which I think

Re: Problem when insert date value in SQL Server

2003-03-24 Thread Michael A Chase
he last sentence in the paragraph below. > -Mensaje original- > De: Michael A Chase [mailto:[EMAIL PROTECTED] > Enviado el: lunes, 24 de marzo de 2003 14:20 > Para: Illera, Fernando; [EMAIL PROTECTED] > Asunto: Re: Problem when insert date value in SQL Server > Is th

Re: Problem when insert date value in SQL Server

2003-03-24 Thread Simon Oliver
Illera, Fernando wrote: Thanks Mac. I have tried as you recommended: my($now) = time(); Here's your problem. time() returns the number of seconds since the epoch which I think DBMS will struggle with. You need to convert that time() value to something more usefull, you might get away with th

RE: Problem when insert date value in SQL Server

2003-03-24 Thread Illera, Fernando
2003 14:20 Para: Illera, Fernando; [EMAIL PROTECTED] Asunto: Re: Problem when insert date value in SQL Server On Mon, 24 Mar 2003 13:18:58 +0100 "Illera, Fernando" <[EMAIL PROTECTED]> wrote: > I'm trying to insert date type values in SQL Server 7.0, but I always > get

Re: Problem when insert date value in SQL Server

2003-03-24 Thread Michael A Chase
On Mon, 24 Mar 2003 13:18:58 +0100 "Illera, Fernando" <[EMAIL PROTECTED]> wrote: > I'm trying to insert date type values in SQL Server 7.0, but I always > get the next error: > > DBD::ODBC::st execute failed: [unixODBC] Msg 8115, Level 16, State 2, > Server PROSDK01, Line 1 > > The table in SQL

Problem when insert date value in SQL Server

2003-03-24 Thread Illera, Fernando
Hi, I'm trying to insert date type values in SQL Server 7.0, but I always get the next error: DBD::ODBC::st execute failed: [unixODBC] Msg 8115, Level 16, State 2, Server PROSDK01, Line 1 The table in SQL Server is defined as: create table pruebas (char codigo not null, char valor not null, da