Hi,
I had problems with dates and times too! Once, I managed to make it
work and when
I moved my app to another server It didn't work because of different
locale settings.
So here is my idea : leave the locale away, use some independent string
dates!
I will attach an example also, but it is very simple. O sql ask for a string
field, returned in a
well known and locale independent format!
The Date(string) seems to call internally the Date.parse(string) static
method.
Date.parse(string) will allways understand the 'mm/dd/yyyy' and the 'mm/dd/yyyy
hh:mm:ss'
date formats, whatever locale you have ! It works also in MS IE client JScript
code!
Here it is an example :
var rs=sqlConn.Execute("SELECT CONVERT(varchar,GETDATE(),101) AS TODAY");
var dt_str=rs("TODAY").Value;
var dt_obj=new Date(dt_str); // or new Date(Date.parse(dt_str));
Response.Write(dt_obj.toLocaleString());
bottom line,
if you need a date only string use CONVERT(varchar,DATE_FIELD,101)
if you need a date time string use CONVERT(varchar,GETDATE(),101)+'
'+CONVERT(varchar,GETDATE(),108)
Good Luck!
Regards,
Marius Manolea
""Brinkman, Theodore"" <[EMAIL PROTECTED]> wrote in
message FE8510398BFE854F9653B5C32DBB652FD4F2C3@oh_daytn_xch01">news:FE8510398BFE854F9653B5C32DBB652FD4F2C3@oh_daytn_xch01...
> Let me preface this request by saying that I know this request for help
> isn't quite on-topic, but I haven't found any good places to ask for help
on
> this. Thank you for not flogging me with wet noodles.
>
> Now, on to the question:
> We're having some problems relating to using MS SQL Server 2000 with a
> JavaScript ASP page. (Like I said, seriously ot here.)
>
> We get a datetime value from the database, and need to format it. From
what
> I've been told by the others in the project, they've tried everything they
> can think of to get the SQL Server datetime value stuffed into a
JavaScript
> Date object, but JavaScript doesn't seem to be willing to accept it.
We're
> currently parsing it out by hand, but the code to do so is fugly to say
the
> least.
>
> Anybody here know how to get around this?
>
> - Theo
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
begin 666 date.asp
M/"5 3$%.1U5!1T4]2E-#4DE05"4^#0H\:'1M;#X-"CQH96%D/CQT:71L93Y*
M4V-I<'0@1&%T92!%>&%M<&QE/"]T:71L93X\+VAE860^#0H\8F]D>3X-"CPE
M#0H-"B\J0&-C7V]N0"HO#0IV87(@97)R;W(]9F%L<V4[#0IT<GD-"GL-"@EV
M87(@<W%L0V]N;CU397)V97(N0W)E871E3V)J96-T*")!1$]$0BY#;VYN96-T
M:6]N(BD-"@ES<6Q#;VYN+D]P96XH(D133CU,;V-A;%-E<G9E<CM5240]<V$[
M1$%404)!4T4]4%5"4R(I.PT*"79A<B!R<SUS<6Q#;VYN+D5X96-U=&4H(E-%
M3$5#5"!#3TY615)4*'9A<F-H87(L1T541$%412@I+#$P,2DK)R G*T-/3E9%
M4E0H=F%R8VAA<BQ'151$051%*"DL,3 X*2!!4R!43T1!62(I.PT*"79A<B!D
M=%]S='(]<G,N1FEE;&1S*")43T1!62(I+E9A;'5E.PT*"5)E<W!O;G-E+E=R
M:71E*"(\:#$^4V5R=F5R(%-I9&4@4W1U9F8@+BXN/"]H,3Y<;CQP/EQN/'!R
M93XB*3L-"@EI9BA 7VIS8W)I<'1?=F5R<VEO;CT]0%]J<V-R:7!T7W9E<G-I
M;VXI#0H)"5)E<W!O;G-E+E=R:71E*")*4V-R:7!T('9E<G-I;VX@:7,@(" @
M(" @(" @(" Z("(K0%]J<V-R:7!T7W9E<G-I;VXK(CQB<CY<;B(I.PT*"5)E
M<W!O;G-E+E=R:71E*")4:&4@='EP92!O9B!R971U<FYE9"!F:65L9"!I<R Z
M("<B*W1Y<&5O9BAD=%]S='(I*R(G/&)R/EQN(BD[#0H)4F5S<&]N<V4N5W)I
M=&4H(E1H92!R971U<FYE9" @9FEE;&0@:7,@(" @(" @(#H@)R(K9'1?<W1R
M*R(G/&)R/EQN(BD[#0H)=F%R(&1T7V]B:CUN97<@1&%T92AD=%]S='(I.PT*
M"5)E<W!O;G-E+E=R:71E*")4:&4@;F5W($1A=&4H)R(K9'1?<W1R*R(G*2!I
M<R Z("<B*V1T7V]B:BYT;TQO8V%L95-T<FEN9R@I*R(G/&)R/EQN(BD[#0H)
M4F5S<&]N<V4N5W)I=&4H(CPO<')E/EQN/"]P/EQN(BD[#0H)<W%L0V]N;BY#
M;&][EMAIL PROTECTED]*?0T*"6-A=&-H*&5R<BD-"@E[#0H)"65R<F]R/71R=64[#0H)
M"5)E<W!O;G-E+D-L96%R*"D[#0H)"5)E<W!O;G-E+E=R:71E*")%<G)O<B Z
M("(K97)R+F1E<V-R:7!T:6]N*3L-"@E]#0II9BAE<G)O<BD-"GL-"@E397-S
M:6]N+D%B86YD;VXH*3L-"@E297-P;VYS92Y%;F0H*3L-"GT-"F5L<V4-"GL-
M"B4^#0H\<#X\8G(^/"]P/@T*/&@Q/D-L:65N="!S:61E('-T=69F("XN+CPO
M:#$^#0H\<#X-"CQP<F4^#0H\4T-225!4($Q!3D=504=%/4I30U))4%0^#0HO
M*D!C8U]O;D J+PT*"79A<B!D=%]S='(](CPE/61T7W-T<B4^(CL-"@EV87(@
M9'1?;V)J/6YE=R!$871E*&1T7W-T<BD[#0H):68H0%]J<V-R:7!T7W9E<G-I
M;VX]/4!?:G-C<FEP=%]V97)S:6]N*0T*"0ED;V-U;65N="YW<FET92@B2E-C
M<FEP="!V97)S:6]N(&ES(" @(" @(" @(" @.B B*T!?:G-C<FEP=%]V97)S
M:6]N*R(\8G(^7&XB*3L-"@ED;V-U;65N="YW<FET92@-"@D)(E1H92!N97<@
M1&%T92@G(BMD=%]S='(K(B<I(&ES(#H@)R(K#0H)"61T7V]B:BYT;TQO8V%L
M95-T<FEN9R@I*PT*"0DB)SQB<CY<;B(I.PT*/"]30U))4%0^#0H\+W!R93X-
D"CPO<#X-"CPE#0I]#0HE/@T*/"]B;V1Y/@T*/"]H=&UL/@T*
`
end
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
