Re: Date field in sql builder

Article View: borland.public.vdbase.data.sql

Article #151

Back to borland.public.vdbase.data.sql Previous Next

#151

From: Romain Strieff [TeamB]
Date: Thu, 04 Mar 1999 00:00

17 lines
1183 bytes

In article <36e4e115.7047839@forums.inprise.com>, Steve Koterski politely 
paraphrased ...
> And, to take Ken's expansion of Bowen's answer just one step further...
> 
> Since the original poster is in Belgium, I would remindhim that local SQL
> is not localized. The date portion of DATE and TIMESTAMP literals must be
> in the US format, with month before date.
--
But only if you use the slash as separator, if you use the dot, it works. 
It seems to think it's US dates only when it sees the "/"

-- 
Romain Strieff [TeamB]
Please read this newsgroup guide below before 
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--

Technical Details

Message-ID: <MPG.114868a19e128ae3989fa1@forums.inprise.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7bk1bs$2i77@forums.borland.com> <36ddce30.1329713@forums.borland.com> <36e4e115.7047839@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,9c0ce2ccf9b5c6e5
X-Google-Attributes: gidff5a1,public
From: teamb@opto-pps.com (Romain Strieff [TeamB])
Subject: Re: Date field in sql builder
Date: 1999/03/04
Message-ID: <MPG.114868a19e128ae3989fa1@forums.inprise.com>
X-Deja-AN: 451097632
References: <7bk1bs$2i77@forums.borland.com> <36ddce30.1329713@forums.borland.com> <36e4e115.7047839@forums.inprise.com>
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message