Article View: borland.public.interbase.sql
Article #840Re: Date format problem
From: Bill Todd
Date: Wed, 23 May 2007 20:16
Date: Wed, 23 May 2007 20:16
7 lines
1212 bytes
1212 bytes
Use a parameterized query where the datetime value is a parameter. Then all you have to do is assign the value to the parameter and let the server handle the conversion. This is always the best way to handle date and time literals in SQL. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<4654a104@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news3.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>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>
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: <4654a104@newsgroups.borland.com>
Date: 23 May 2007 13:16:04 -0700
X-Trace: newsgroups.borland.com 1179951364 216.207.211.19 (23 May 2007 13:16:04 -0700)
Lines: 7
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news3.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