Article View: borland.public.interbase.sql
Article #843Re: Date format problem
From: Bill Todd
Date: Wed, 23 May 2007 21:55
Date: Wed, 23 May 2007 21:55
16 lines
1474 bytes
1474 bytes
AntonE wrote: > > Use a parameterized query where the datetime value is a parameter. > > Thanks, but I cannot do that as of yet, I can only send the whole > query as a text message,already parsed, prepared & ready to go, as if > running it in IBConsole. Not using DB client/server, just plain TCP > text connections. > > AntonE Then you _will_ have problems with machines using different locales as well as different database servers. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<4654b859$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<46549b87@newsgroups.borland.com> <4654a104@newsgroups.borland.com> <4654a791@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,61360681df372f16
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Date format problem
Newsgroups: borland.public.interbase.sql
References: <46549b87@newsgroups.borland.com> <4654a104@newsgroups.borland.com> <4654a791@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <4654b859$1@newsgroups.borland.com>
Date: 23 May 2007 14:55:37 -0700
X-Trace: newsgroups.borland.com 1179957337 216.207.211.19 (23 May 2007 14:55:37 -0700)
Lines: 16
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail