Article View: borland.public.interbase.sql
Article #967Re: INSERT date format
From: Bill Todd
Date: Mon, 02 Apr 2007 14:16
Date: Mon, 02 Apr 2007 14:16
7 lines
1227 bytes
1227 bytes
The easy solution is to use parameters for the dates. Then you do not have to worry about the date format. If you want to use literals for some reason the allowable date formats are in the IB manuals (I cannot remember where at the moment). -- Bill Todd (TeamB)
Technical Details
Message-ID:
<4611021f$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!217.73.144.44.MISMATCH!ecngs!feeder.ecngs.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4610e304$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,cf151f5501431f39
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: INSERT date format
Newsgroups: borland.public.interbase.sql
References: <4610e304$1@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: <4611021f$1@newsgroups.borland.com>
Date: 2 Apr 2007 06:16:15 -0800
X-Trace: newsgroups.borland.com 1175519775 216.207.211.19 (2 Apr 2007 06:16:15 -0800)
Lines: 7
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!217.73.144.44.MISMATCH!ecngs!feeder.ecngs.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail