access_asp thread: Bad date format
Message #1 by "Marcelo" <foros@f...> on Fri, 5 Oct 2001 14:30:09 -0300
|
|
Hello
I've this sql string:
insert into registros (id_fam, id_cat, reg_text, reg_date, reg_venc,
reg_todo, reg_prior) values ('7', '24', '01', '05/10/2001 12:06:08', null,
'', '3')
also
insert into registros (id_fam, id_cat, reg_text, reg_date, reg_venc,
reg_todo, reg_prior) values ('7', '24', '01', '05/10/2001 12:06:08',
'05/10/2001 12:06:08', '', '3')
both of them in 2 machines with the same Regional configuration, so on both
machines the string was EXACTLY the same.
The database is Access, connected by a connection string (not DSN), Win 2000
Eng and Regional Settings Spanish.
When inserting tha data on both computers, the one on which the database
resides, load the date in dd/mm/yyyy...all the another accessing by the web
loads in mm/dd/yyyy
What may be wrong if the sql statement is the same?
Thanks.
Marcelo
Message #2 by "sahas lad" <sahas_lad@h...> on Sat, 06 Oct 2001 05:18:18 +0000
|
|
Hi
Firstly check out the date format in Access & try.
>From: "Marcelo" <foros@f...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Bad date format
>Date: Fri, 05 Oct 2001 18:58:49 +0100
>
>Hello
>
>I've this sql string:
>insert into registros (id_fam, id_cat, reg_text, reg_date, reg_venc,
>reg_todo, reg_prior) values ('7', '24', '01', '05/10/2001 12:06:08', null,
>'', '3')
>
>also
>
>insert into registros (id_fam, id_cat, reg_text, reg_date, reg_venc,
>reg_todo, reg_prior) values ('7', '24', '01', '05/10/2001 12:06:08',
>'05/10/2001 12:06:08', '', '3')
>
>both of them in 2 machines with the same Regional configuration, so on both
>machines the string was EXACTLY the same.
>
>The database is Access, connected by a connection string (not DSN), Win
>2000
>Eng and Regional Settings Spanish.
>
>When inserting tha data on both computers, the one on which the database
>resides, load the date in dd/mm/yyyy...all the another accessing by the web
>loads in mm/dd/yyyy
>
>What may be wrong if the sql statement is the same?
>
>
>Thanks.
>
>Marcelo
>
>
Message #3 by "Marcelo" <foros@f...> on Sat, 6 Oct 2001 11:50:49 -0300
|
|
The date is ok in access...it was in General Date, but I also tried as
CUSTOM FORMAT, as access help says...I entered un the date format:
dd/mm/yyyy hh:nn:ss with the same results (is that the Custom Format?
Also in all my pages, I set the date format to Spanish, and the server
Locale settings, is also Spanish......any other place to see?
Marcelo
----- Original Message -----
From: "sahas lad" <sahas_lad@h...>
To: "Access ASP" <access_asp@p...>
Sent: Saturday, October 06, 2001 2:18 AM
Subject: [access_asp] Re: Bad date format
> Hi
> Firstly check out the date format in Access & try.
>
>
>
>
>
> >From: "Marcelo" <foros@f...>
> >Reply-To: "Access ASP" <access_asp@p...>
> >To: "Access ASP" <access_asp@p...>
> >Subject: [access_asp] Bad date format
> >Date: Fri, 05 Oct 2001 18:58:49 +0100
> >
> >Hello
> >
> >I've this sql string:
> >insert into registros (id_fam, id_cat, reg_text, reg_date, reg_venc,
> >reg_todo, reg_prior) values ('7', '24', '01', '05/10/2001 12:06:08',
null,
> >'', '3')
> >
> >also
> >
> >insert into registros (id_fam, id_cat, reg_text, reg_date, reg_venc,
> >reg_todo, reg_prior) values ('7', '24', '01', '05/10/2001 12:06:08',
> >'05/10/2001 12:06:08', '', '3')
> >
> >both of them in 2 machines with the same Regional configuration, so on
both
> >machines the string was EXACTLY the same.
> >
> >The database is Access, connected by a connection string (not DSN), Win
> >2000
> >Eng and Regional Settings Spanish.
> >
> >When inserting tha data on both computers, the one on which the database
> >resides, load the date in dd/mm/yyyy...all the another accessing by the
web
> >loads in mm/dd/yyyy
> >
> >What may be wrong if the sql statement is the same?
> >
> >
> >Thanks.
> >
> >Marcelo
> >
>
|
View Cart
