Article View: borland.public.vdbase.data.sql
Article #342Re: SQL and non-US date formats
From: Ivar B. Jessen
Date: Mon, 04 Jan 1999 00:00
Date: Mon, 04 Jan 1999 00:00
20 lines
1259 bytes
1259 bytes
Phillip Hansen skrev: > > > I have used (at somebody's suggestion, can't remember who though) > DD.MM.YYYY successfully, but the English format DD/MM/YYYY will not work. > It was said that it is some SQL internal thing which can translate the . > but not the / > -- Philip, Thank you for a helpful comment. (by the way an English format does not exist, the command is Set date British <g>). It is good to hear that at least the formats set date to German and set mark to "." may be used in sql statements without first converting to a US-format and later convert back to the original format. Ivar B. Jessen
Technical Details
Message-ID:
<3691247A.8679812E@vip.cybercity.dk>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<3687B805.4F3BCAB3@vip.cybercity.dk> <MPG.10f3dddf887b184a9896a7@forums.inprise.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,aa0f3eec63bcbcf7 X-Google-Attributes: gidff5a1,public From: "Ivar B. Jessen" <ccc34145@vip.cybercity.dk> Subject: Re: SQL and non-US date formats Date: 1999/01/04 Message-ID: <3691247A.8679812E@vip.cybercity.dk> X-Deja-AN: 428749725 Content-Transfer-Encoding: 7bit References: <3687B805.4F3BCAB3@vip.cybercity.dk> <MPG.10f3dddf887b184a9896a7@forums.inprise.com> Content-Type: text/plain; charset=us-ascii Organization: Another Netscape Collabra Server User Mime-Version: 1.0 Reply-To: bergishagen@it.dk Newsgroups: borland.public.vdbase.data.sql